Skip to content

Registered aircraft · 17,028

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

N79805Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258207 N7981USkyhawk Aviation LLC · Midland, MIBuilt 1964 · S/N 17251981 N7982FPlane Sane C1 LLC · Cary, NCS/N 15064082 N7982ULastowski Jeffrey A · Mooresville, INBuilt 1964 · S/N 17251982 N7983FKoons Brian D · Canton, OHBuilt 1966 · S/N 15064083 N7983GLuse David C · Newalla, OKBuilt 1971 · S/N 17259683 N7984GChampion Air LLC · Louisville, KYBuilt 1971 · S/N 17259684 N7984UButter Kendall L · Gatesville, TXBuilt 1964 · S/N 17251984 N79873Knuteson Anthony M · Ketchikan, AKS/N 17258208 N79874Morris Steven J · Wasilla, AKBuilt 1969 · S/N 17258209 N79877Feliz Thaisio D · Port Saint Lucie, FLS/N 17258212 N79878Buncher Bruce M · North Royalton, OHBuilt 1969 · S/N 17258213 N79879Scafe Travis W · Tuttle, OKBuilt 1969 · S/N 17258214 N7987FMillican Troy · New Ulm, TXBuilt 1966 · S/N 15064087 N7987GHigh Expose Inc · Woodbine, NJBuilt 1973 · S/N 15074748 N7987UFrick Gary A Trustee · Marion, INBuilt 1964 · S/N 17251987 N79881Kevin Kingsley LLC · Lamar, MOBuilt 1969 · S/N 17258216 N79884Barnhill Laith A · Arlington, WABuilt 1969 · S/N 17258219 N79888Smith Happy E · Rogersville, TNBuilt 1969 · S/N 17258223 N7988GAbad Alain · Miami, FLFirst renewal noticeBuilt 1971 · S/N 17259688 N79890Smith J Francis · Seattle, WAS/N 17258225 N79893Panjab Aviation · Las Vegas, NVBuilt 1969 · S/N 17258228 N79894Watson Mitchell M · Tribune, KSBuilt 1969 · S/N 17258229 N79896Jstream Lc · Sheridan, WYBuilt 1969 · S/N 17258231 N79898Aero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258233 N7989GWhite Jeffery G · Sagaponack, NYS/N 17259689 N7989UA-Cent Aviation Inc · Jacksonville, FLBuilt 1964 · S/N 17251989 N79900Fogle Bruce A · Valparaiso, INBuilt 1969 · S/N 17258235 N79902Trainer Edward A Jr · Beaver Falls, PABuilt 1969 · S/N 17258236 N79904Skyhawk904 LLC · Ventura, CABuilt 1969 · S/N 17258238 N79905Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258239 N79908Taylor Craig D · Walker, MNS/N 17258241 N79915Jersey Aviation LLC · East Orange, NJS/N 17258244 N79917Cagle Duane K · Hideaway, TXS/N 17258245 N79919Dsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258247 N79920Rtd Aviation LLC · Hillsborough, NJBuilt 1969 · S/N 17258248 N79921Cessna N79921 Inc · Lowell, MIBuilt 1969 · S/N 17258249 N79924Leonard Martin D · Aguanga, CAS/N 17258252 N79929S & C Aero LLC · Collierville, TNBuilt 1969 · S/N 17258256 N7992GSalifu Zakare · Bowling Green, KYBuilt 1971 · S/N 17259692 N79932Jordan Ronald G · Kiln, MSBuilt 1969 · S/N 17258259 N79934Watson Marlys W · Zebulon, GABuilt 1969 · S/N 17258261 N79938Levin Robert · Roseburg, ORS/N 17258265 N79939Southeast Aviation Services Inc · Hattiesburg, MSBuilt 1969 · S/N 17258266 N7993UKrecek Jason · Hiram, OHS/N 17251993 N79941Dunham Robert H · Kansas City, MOBuilt 1969 · S/N 17258268 N79943Wallis Bruce W · Kingwood, TXBuilt 1969 · S/N 17258270 N79945Iron Horse Cub LLC · Granbury, TXBuilt 1969 · S/N 17258272 N79946Yakey W R · Stewardson, ILBuilt 1969 · S/N 17258273 N79948Seawings LLC · Holualoa, HIBuilt 1969 · S/N 17258275

Back to AD 72-03-03 R3