AD 75-06-01
Registered aircraft · 2,832
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
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:75-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-06-01')
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:75-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-06-01') 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.
N262AGMcneely Charter Service Inc · West Memphis, ARN263CWAir Pard LLC · Baton Rouge, LAN263JCAllen Chorman & Son Inc · Milton, DEN263RSNorthern Sky Leasing LLC · Middletown, DEN264B264b LLC · Wilmington, DEN264BRKeller James B · Palo Alto, CAN264DKStonewall Aviation LLC · Murfreesboro, TNN265KQRyffel Aviation LLC · Fort Worth, TXN266RDGuardian Flight LLC · Lewisville, TXN267KQFp Winters LLC · Newark, DEN269MVMavi8 LLC · Sedona, AZFirst renewal noticeN26EDynamic Avlease Inc · Bridgewater, VAN26TGKenmore Crew Leasing Inc Trustee · Bellingham, WAN270CLRegistration Pending · Chesterfield, MORegistration pendingN271SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN271ZRegistration Pending · Helena, MTRegistration pendingN272GXFreedom Aviation LLC · Anaconda, MTN272ZZBig Flats LLC · Durham, NCN274PMPlanemasters Ltd · West Chicago, ILFirst renewal noticeN275LARts Ventures LLC · San Antonio, TXN275LHProject Tango Inc Trustee · Wilmington, DEN276JBChris Allen Aviation LLC · Naples, FLN276MABank Of Utah Trustee · Salt Lake City, UTN277GERltwf LLC · Fiddletown, CAN277GLDiamondback Equipment Leasing LLC · Avondale, AZN278JLarkin Matthew W · Lafayette, CAN278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN279KQLmg-Rba LLC · Georgetown, TXN27BFJab Air LLC · Ponte Vedra Beach, FLN27BNTravelaire Service Inc · Wilmington, DEN27MGAvion Capital Corp · Anchorage, AKN280SPSan Pablito Ranch Aviation LLC · Hebbronville, TXN280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKN282PMPlanemasters Ltd · West Chicago, ILN283JDDurham Aircraft LLC · Port Aransas, TXN283PMPlanemasters Ltd · West Chicago, ILN284PMArtic Legacy Aviation LLC · Anchorage, AKN285KCCourt Reporter Assignments Inc · Bullhead City, AZN285PBBank Of Utah Trustee · Salt Lake City, UTN285RBButler National Inc · New Century, KSN286PMPlanemasters Ltd · West Chicago, ILN287JJA L S A P Enterprises LLC · Missoula, MTN288AFMod-Pac Corp · Portsmouth, NHN288ATN38ry LLC · California, MDN289ATN999mg LLC · California, MDN289PCTuca 27 LLC · Lewes, DEN28ANPa1 208b-0751 LLC · Fort Lauderdale, FLN28NRJaars Inc · Waxhaw, NCN28VRPajaro 195 LLC · Fort Worth, TXN2904GMec Aviation Kodiak LLC · Gainesville, GA
Back to AD 75-06-01