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.

N7514TRohsner Thomas A · Nacogdoches, TXS/N 47114 N7514XBrown Thomas · Austin, TXS/N 17248014 N7515TGbl Leasing LLC · Gun Barrel City, TXBuilt 1959 · S/N 47115 N7515XSnap Aviation LLC · Athens, PABuilt 1960 · S/N 17248015 N7516TSchehl Darren C · Gahanna, OHBuilt 1959 · S/N 47116 N7517XHalley Dan R · Avery, TXBuilt 1960 · S/N 17248017 N7518TWilliams Doyle D · Browning, MOS/N 47118 N7519TScud Air 19t LLC · Morgan, UTBuilt 1959 · S/N 47119 N7519XSouthern Moulding Acquisition LLC · Marietta, GABuilt 1960 · S/N 17248019 N751BKGeneral Aviation LLC · Henderson, NVBuilt 1978 · S/N 17270335 N751CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11572 N751DWGaskins Frank E · Ashland, VABuilt 1981 · S/N 172RG1002 N751MLQueensland Air LLC · Chicago, ILFirst renewal noticeBuilt 2001 · S/N 172S8754 N751SPHagele Aviation LLC · Hillsboro, ORBuilt 2000 · S/N 172S8684 N7520THartley Chester E · Holts Summit, MOBuilt 1959 · S/N 47120 N7520XSunwave Land LLC · Big Spring, TXBuilt 1960 · S/N 17248020 N7521TPerry Kenneth C Jr · Tucson, AZBuilt 1959 · S/N 47121 N7521XWainwright Donald W · Live Oak, FLS/N 17248021 N7522TMoffitt Michael M · Wolcottville, INBuilt 1959 · S/N 47122 N7522XZitterkopf Gary N · Casper, WYBuilt 1960 · S/N 17248022 N7523GTriple J Aviation LLC · Mcconnelsville, OHBuilt 1970 · S/N 17259223 N7524GBrandywine Sky Ramblers LLC · West Chester, PABuilt 1970 · S/N 17259224 N7524TBohn Flying LLC · Tijeras, NMBuilt 1959 · S/N 47124 N7526GFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1970 · S/N 17259226 N7526TJennen David · Erhard, MNBuilt 1960 · S/N 47126 N7526XWeickum Lee A · Monroe, ORBuilt 1960 · S/N 17248026 N7527TButcher Isis F · Marietta, OKBuilt 1959 · S/N 47127 N7527XRankin Scott W · Kansas City, MOBuilt 1960 · S/N 17248027 N7528GSale Reported · Rillito, AZSale reported, pending cancellationBuilt 1970 · S/N 17259228 N7528XJewell Burton Connor Jacob · Pensacola, FLBuilt 1960 · S/N 17248028 N7529U20 Awesome LLC · Albuquerque, NMBuilt 1962 · S/N 17248795 N7529XBrown Anthony W · Sacramento, KYS/N 17248029 N752DWFlying Start Aero Services LLC · Reno, NVBuilt 2001 · S/N 172S8752 N752EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13553 N7530TBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 47130 N7531TJanke Gregory A · Lompoc, CABuilt 1959 · S/N 47131 N7532TVan Voast Carla J · Turner, MTBuilt 1959 · S/N 47132 N7532XRoy John L · Edmonds, WABuilt 1960 · S/N 17248032 N7533THansman Jon C · Ashland, WIFirst renewal noticeBuilt 1959 · S/N 47133 N7533XRegistration Pending · Lincoln, NDRegistration pendingBuilt 1960 · S/N 17248033 N7534TFreudenthal Timothy M · Wautoma, WIBuilt 1959 · S/N 47134 N7535TStearman Matthew G · Andale, KSBuilt 1959 · S/N 47135 N7535XLilley Jeffery L · Buffalo, MOBuilt 1960 · S/N 17248035 N7536TD&K Ag Service Inc · Lantry, SDS/N 47136 N7538TClark Walter A Jr · Willcox, AZBuilt 1959 · S/N 47138 N7538XSpratt John G · Watkinsville, GABuilt 1960 · S/N 17248038 N7539TCropper Kenneth B · Orangeville, UTBuilt 1959 · S/N 47139 N7539XWalnut Valley Aviation LLC · Wilmington, DEBuilt 1960 · S/N 17248039 N753GWAtp Aircraft 4 LLC · Wilmington, DEBuilt 2001 · S/N 172S8753 N753LAJoy Air LLC · Scottsdale, AZBuilt 2023 · S/N 172S13113

Back to AD 90-06-03 R1