Skip to content

Registered aircraft · 6,915

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N501BTCloud Chasers LLC · Columbus, MSBuilt 1976 · S/N 32R-7780039 N501DMNeely Aviation Services Corp · Port Orange, FLS/N 34-7870375 N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194 N501WPTrue Course Aviation LLC · Ashville, NYBuilt 1977 · S/N 32R-7780476 N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23 N5020SSchneider Robert R · Fort Benton, MTS/N 28R-35753 N5020TBetlach Christopher Thomas · Kenmore, WABuilt 1972 · S/N 28R-7235175 N5023SSummit Arrow Adventures LLC · Peyton, COBuilt 1970 · S/N 28R-35759 N5024SGuy Timothy S · Henderson, NVBuilt 1970 · S/N 28R-35760 N5025SAir Cover Academy LLC · Frankford, MOBuilt 1970 · S/N 28R-35761 N5027SRatliff Thomas E · Tomball, TXS/N 28R-35771 N5027TMohre Steve G · Blakeslee, OHBuilt 1972 · S/N 28R-7235177 N5028SSmith David J · Elkhart, INBuilt 1970 · S/N 28R-35772 N5028TDrake Charles R · Claremore, OKBuilt 1972 · S/N 28R-7235178 N5029PJordan Walter B · Chehalis, WABuilt 1958 · S/N 2432 N5029SChop Bert D · Oak Grove, LABuilt 1970 · S/N 28R-35775 N502DWSolamich Aviation LLC · Huntley, ILBuilt 1971 · S/N 39-124 N5031SBrodowsky Thomas · West Bloomfield, MIBuilt 1970 · S/N 28R-35790 N5033SGpsp Aviation LLC · Bronx, NYBuilt 1970 · S/N 28R-35762 N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37 N5034SPlattsmouth Aviation LLC · Plattsmouth, NES/N 28R-35801 N5035SReady Airways LLC · Roseville, CABuilt 1970 · S/N 28R-35766 N5036SArrow II Flyers LLC · Jacksonville, FLBuilt 1970 · S/N 28R-35804 N5037SGannon Gary L · Cumberland, WIS/N 28R-35781 N5037TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250205 N5038SRegistration Pending · Fort Worth, TXRegistration pendingS/N 28R-35806 N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165 N5041SZelener Howard M · Redlands, CABuilt 1970 · S/N 28R-35788 N5042SBlair & Company Aero Partners LLC · Raleigh, NCBuilt 1971 · S/N 28R-7135117 N5042TWells Thomas R · Chicago, ILBuilt 1972 · S/N 28R-7235182 N5045PMccarty Paul S · Wichita, KSBuilt 1958 · S/N 24-49 N5048PBrown Mark E · Charlotte, NCBuilt 1958 · S/N 24-52 N5049TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250210 N5050PBoucher Bobbi · Fredericksburg, VAS/N 24-54 N5051PGrorud James R · Milbank, SDBuilt 1958 · S/N 24-55 N5051SCall Of The Loon LLC · Missoula, MTBuilt 1971 · S/N 28R-7135118 N5051TOverton Asset Group LLC · Saint Marys, IABuilt 1972 · S/N 34-7250237 N5052SWonnacott Dereck · Auburn Hills, MIBuilt 1970 · S/N 28R-35805 N5053SAviation Capital Management LLC · San Jose, CABuilt 1970 · S/N 28R-35808 N5054SWoodson Billy R · Elon, NCBuilt 1970 · S/N 28R-35814 N5055SBattaile Jesse K · Chevy Chase, MDS/N 28R-35789 N5055TArrow 5055t LLC · Saint Helena, CABuilt 1972 · S/N 28R-7235186 N5058PBakeman Michael G · Sturgis, MIBuilt 1958 · S/N 24-507 N505BJLa Beau Lawrence O · San Angelo, TXBuilt 1961 · S/N 24-2331 N505GAlford Robert S · Columbus, GARegistration revokedBuilt 1964 · S/N 30-251 N5060TAirzona Aircraft Services Inc · Kingman, AZBuilt 1972 · S/N 28R-7235187 N5061TSullivan Patrick James · Avery, CABuilt 1972 · S/N 28R-7235188 N5063SLancon James B · Prescott, AZBuilt 1970 · S/N 28R-35812 N5065PVeal Ted W · Homer, AKS/N 24-71 N5066PDelaware Aviation LLC · Sidney, NYBuilt 1958 · S/N 24-72

Back to AD 97-01-01 R1