Skip to content

Registered aircraft · 54,017

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N3140XGerasimov Gennady · Jefferson City, MOBuilt 1966 · S/N 15064540 N3140YParker Mccrum LLC · Eugene, ORBuilt 1962 · S/N 18254140 N3141AHoppe Joel A · Mankato, MNBuilt 1953 · S/N 25785 N3141BGoettemoeller Matthew W · Oldtown, IDBuilt 1952 · S/N 25383 N3141DNelson Donald W · Aurora, COBuilt 1955 · S/N 31939 N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449 N3141FDoerr John · Sandy, ORBuilt 1966 · S/N 18257241 N3141RIncze Bela · Morgan Hill, CABuilt 1967 · S/N 18258541 N3141SValley Excavation And Grading Inc · Chatsworth, CABuilt 1964 · S/N 18255641 N3141TN3141t LLC · Saint Johns, MIBuilt 1967 · S/N 17700441 N3141UMo2 Investing LLC · Springfield, MOS/N 18254541 N3141VRenner Thomas J · Williston, NDS/N 15076399 N3141XMalo Lee M · Peabody, MABuilt 1966 · S/N 15064541 N3142AKrueger Robert C · Glenburn, MEBuilt 1953 · S/N 25786 N3142CItm Electronics Inc · Greenleaf, IDBuilt 1954 · S/N 30941 N3142QRogers James · Summerfield, FLBuilt 1967 · S/N 18258142 N3142RSharp Media Group LLC · Kansas City, MOS/N R18201117 N3142SB&G Aircraft LLC · Greensboro, GABuilt 1964 · S/N 18255642 N3142TTri State Airmotive LLC · Berryville, ARS/N 17700442 N3142YOdom Aviation Inc · Cabot, ARS/N 18254142 N3143ASkyline Holdings LLC · Big Lake, AKBuilt 1953 · S/N 25787 N3143QJlm Management LLC · Clarion, PABuilt 1967 · S/N 18258143 N3143RNelson John J · Salmon, IDBuilt 1967 · S/N 18258543 N3143UTimuuu Inc · Alden, NYBuilt 1963 · S/N 18254543 N3143VWebb Hunter · Altonah, UTBuilt 1974 · S/N 15076401 N3144JChaffey Union Junior College District · Alta Loma, CABuilt 1966 · S/N 15065844 N3144QRichmond Brian · Rhome, TXBuilt 1967 · S/N 18258144 N3144RGivens Mickey M · Crosbyton, TXBuilt 1967 · S/N 18258544 N3144SMyers Dathan Dh · Port Angeles, WABuilt 1964 · S/N 18255644 N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444 N3145QN3145q LLC · Cave Creek, AZBuilt 1967 · S/N 18258145 N3145RSchnell Tyler C · Spearman, TXBuilt 1967 · S/N 18258545 N3145SCorriher Ronald R · Mount Ulla, NCBuilt 1964 · S/N 18255645 N3145YSiskiyou Aviation LLC · San Jose, CABuilt 1962 · S/N 18254145 N3146FMeyer Jackson · Soldotna, AKBuilt 1966 · S/N 18257246 N3146QJpw LLC · Red Lodge, MTBuilt 1967 · S/N 18258146 N3146RBednarik Edward L · Morgantown, PABuilt 1967 · S/N 18258546 N3146UAscend Aviation LLC · Post Falls, IDS/N 18254546 N3147CSchlutz Ivan F · Longmont, COBuilt 1954 · S/N 30946 N3147JRegistered aircraftS/N 15065847 N3147QBernbeck Alan R · Benton, KSBuilt 1967 · S/N 18258147 N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447 N3147XSuperior Golf Course Maintenance LLC · Plantation, FLBuilt 1966 · S/N 17255297 N3148CFreund Timothy P · Mesa, AZBuilt 1954 · S/N 30947 N3148JWoerle Edward R · Rossville, TNBuilt 1966 · S/N 15065848 N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945 N3148RMyl High Flying Club LLC · Mccall, IDBuilt 1967 · S/N 18258548 N3148SHauser Family Flying LLC · Mount Pleasant, PABuilt 1964 · S/N 18255648 N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448 N3148VConnor Gavin · Owensboro, KYBuilt 1974 · S/N 15076402

Back to AD 87-20-03 R2