Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N869EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12679 N869FGMustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10346 N86BJWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280238 N86DBMchugh John J · Camano Island, WABuilt 1970 · S/N 17259123 N86ERInnovative Aerial Solutions LLC · Saint Johns, FLBuilt 1983 · S/N 17276027 N86FPGateway Flight Center LLC · Port Lavaca, TXBuilt 1978 · S/N 17271406 N86VBAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263670 N8700BWall Bernardo · Seminole, TXS/N 36400 N8702BHill Thomas Gerald · Port Tobacco, MDBuilt 1957 · S/N 36402 N8703UNea Construction LLC · Jonesboro, ARBuilt 1965 · S/N 17252607 N8705BCarney David M · Mc Allister, MTS/N 36405 N8706BCox Robert D · Caldwell, IDBuilt 1957 · S/N 36406 N8707BEmblom Donald B · Hackensack, MNBuilt 1957 · S/N 36407 N8708UDewey William H Trustee · Eugene, ORBuilt 1965 · S/N 17252612 N8709BBaldwin Steve · Lawson, MOBuilt 1957 · S/N 36409 N8709UWilkinson James Richard · Carlsbad, NMBuilt 1965 · S/N 17252613 N870CPAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280666 N870EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13514 N870SPEstern Kentucky University · Richmond, KYBuilt 1999 · S/N 172S8130 N870TWSouthern Haulers LLC · Leachville, ARBuilt 1973 · S/N 17261565 N8710UDmac Aircraft LLC · Savannah, GABuilt 1965 · S/N 17252614 N8711BHubert Gregory D · Charles Town, WVBuilt 1957 · S/N 36411 N8715BSchultz John J · Kenai, AKS/N 36415 N8716UWings Of Hope · Chesterfield, MOBuilt 1965 · S/N 17252620 N8717BNorsic Michael · Parma, OHBuilt 1957 · S/N 36417 N8718UPuckett Matthew Scott · Argyle, TXBuilt 1965 · S/N 17252622 N8719BSale Reported · Westerville, NESale reported, canceledS/N 36419 N871CPRedstone Arsenal Flying Activity · Redstone, ALBuilt 1999 · S/N 17280687 N871EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13517 N8722BBuell Jack A · St Maries, IDBuilt 1957 · S/N 36422 N8722UBrown Stephen L · Charlotte, MIBuilt 1965 · S/N 172-52626 N8723UTraining Services Inc T/A · Virginia Beach, VABuilt 1965 · S/N 17252627 N8724BMcmahon William · Westville, INS/N 36424 N8725UArklamiss Aviation LLC · Ruston, LABuilt 1965 · S/N 17252629 N8726BEckles Phillip · Holdenville, OKBuilt 1957 · S/N 36426 N8726UHowell Harley L · Colville, WAS/N 17252630 N8729BChristian Melvin Lee Jr · Apison, TNBuilt 1957 · S/N 36429 N8729UEpmeier Bruce E · Newburgh, INBuilt 1965 · S/N 17252633 N872EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13520 N872FALewis University · Romeoville, ILBuilt 2002 · S/N 17281109 N872FCBlackhawk Holding Corp · Wilmington, DEBuilt 1980 · S/N 17273875 N872FSTfs Air LLC · Loveland, COBuilt 2003 · S/N 17281172 N872NCMt Vernon Airport Authority · Mount Vernon, ILBuilt 1981 · S/N 17274780 N872SPChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8134 N8732UHumke John D · Eufaula, OKS/N 17252636 N8734UGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17252638 N8735UJkh Aviation LLC · Cumming, GABuilt 1965 · S/N 17252639 N8736BCampbell Jack G · Spring Valley, WIBuilt 1957 · S/N 36436 N8736UC & M Aviation Holdings LLC · Brockport, NYBuilt 1965 · S/N 17252640 N8737BFranklin Rodney S · Burns, ORBuilt 1957 · S/N 36437

Back to AD 90-06-03 R1