Skip to content

Registered aircraft · 85,612

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N31407Montei Nicholas P · Caro, MIS/N 32-7840130 N3140ASzablowski Walter · Riegelsville, PABuilt 1953 · S/N 25784 N3140CAthens William A · Missoula, MTBuilt 1954 · S/N 30939 N3140FWilliams Thomas G · Richland Center, WIBuilt 1966 · S/N 18257240 N3140GBynum Aviation LLC · New Albany, MSS/N 3257433 N3140SLavell Michael J · Blue Mounds, WIS/N 18255640 N3140VLayton Matthew K · Mesa, AZS/N D-569 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 N3141UMo2 Investing LLC · Springfield, MOS/N 18254541 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 N3142YOdom Aviation Inc · Cabot, ARS/N 18254142 N3143ASkyline Holdings LLC · Big Lake, AKBuilt 1953 · S/N 25787 N3143JLyden Air LLC · Walbridge, OHBuilt 2006 · S/N 3257427 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 N31444Crossen John R · San Pedro, CABuilt 1988 · S/N CE-1277 N3144HT And C Corp · Wilmington, DEFirst renewal noticeBuilt 1987 · S/N CE-1191 N3144MWhite Ice Holdings LLC · Santa Rosa Beach, FLBuilt 1987 · S/N CE-1206 N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075 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 N3144YSierra Bravo Zulu LLC · Middletown, DES/N E-2437 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 N3145VClonts Dale · Safford, AZBuilt 1947 · S/N D-575 N3145WIfly Aviation LLC · Conway, ARBuilt 1973 · S/N E-505 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 N3146VWittmeyer Jamie J · Wyomissing, PABuilt 1947 · S/N D-756 N3146WWalker Ernest F · Bala Cynwyd, PABuilt 1973 · S/N CE-479 N3147CSchlutz Ivan F · Longmont, COBuilt 1954 · S/N 30946 N3147DOrr Calvin L · Higginsville, MOBuilt 1968 · S/N 32-40412 N3147LBrowning Charles H III · Woodbine, MDBuilt 1994 · S/N E-2882

Back to AD 98-21-21 R1