AD 75-09-13
Registered aircraft · 4,787
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-09-13')
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-09-13')
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-09-13') 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-09-13') 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.
N4888CGoflight Inc · Birmingham, MIN4888FTaktos Ltd · Corvallis, ORN488RHI F Rooks & Associates LLC · Memphis, TNN488SSale Reported · Friday Harbor, WASale reported, pending cancellationN488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeN4895YKeating George W · Fayetteville, ARN4896KBraxtal LLC · Kingfisher, OKN4898CPalo Aerocraft Inc · Salem, VAN48AMGwc Air LLC · Madison, ALN48VAGeiser Corbin · Little Elm, TXN48WCBaron Acquisition LLC · Wayne, PAN4905CAnacapa Capital LLC · Fresno, CAN4909YFremont Airways LLC · Riverton, WYN490KMRasf414 LLC · Hallandale Beach, FLN490MLegacy Ofs Construction LLC · Stillwater, OKN4911JDarter Lloyd R · Mountain Grove, MON4913JPassmore Stephen B DBA · Lacrosse, WAN4918UMission Aviation Fellowship · Nampa, IDN491ACEw Pegasus LLC · Walnut Creek, CAN491WMRenlim Aviation LLC · Brookhaven, GAN4922YHowey Aviation LLC · Woodhaven, MIN4925KAlberts Nelson · Weatherford, TXN4937JSwirsding David J · Chalfont, PAN4939YDavidson Dan F · Ozona, TXN4940KGoves Abram M · Parker, CON4945MMidland College · Midland, TXN4946KOrion Technology Group LLC · San Diego, CAN4948AKeystone Aerial Surveys Inc · Philadelphia, PAN4949ASw Air LLC · Denver, CON494TSDeep Creek Lake Ventures LLC · Oakland, MDN495495htsi LLC · Wilmington, DEN4950UAerotech Mapping Inc · Las Vegas, NVN4951YH & B Aeronautics LLC · Miamisburg, OHN4957ZGuinasso Kimberly Marsh · Reno, NVN4959CDoll House Properties Inc · Chesapeake, VAN4960JPonderosa Airtankers LLC · Safford, AZN4960KShuck Drilling Co · Edgar, NEN4967KBrown Lawson M II DBA · San Diego, CAN4978UKempf Rodney G · Eugene, ORN4981CWatson Michael · Dalhart, TXN4981KCuriel Gabriel · Oakley, CAN4991MOakview Homes LLC · Sullivan, MON4994KMenefee Jerry V · Carson City, NVN499CAHyannis Air Service Inc · Hyannis, MAN499DLCjrr Consulting LLC · Denver, CON499WWLakes Air LLC · Fargo, NDN49AJLvml Real Estate Investments LLC · Rio Grande City, TXN49ARMoore Thomas A · Kennewick, WAN49STHedeen Arnold R · Seattle, WAN4ADValiair Lc Trustee · Casper, WY
Back to AD 75-09-13