AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N134DMMoore Keith · Aspermont, TXN134JAOld School Aircraft LLC · Jackson, TNN1350BHeiderscheidt Sam T · Hector, MNN1350DBock Ray P · Alpena, MIN1350FButler Kendall L · Gatesville, TXN1350KLewis John E · Claytonon, NJN1350YI Buy U Fly LLC · Prescott Valley, AZN1351DReep Jennifer B · Stone Mountain, GAN1351YSumrall Richard C · Village Mills, TXN1352FDtm Enterprises Inc · Bronson, MIN1352HMorris Dennie R · North Fort Myers, FLN1352YGarza James · Palm Beach Gardens, FLN1353BShaw James J · Loranger, LAN1353HHeredia Richard A · Gilroy, CAN1354BStieber Joe · Brownwood, TXN1354DKepler Rodney S · Fargo, NDN1354HOwen Toy C · Anchorage, AKN1354QBaker Wayne E · Crossville, TNN1355AStanton Fred H · Amherst, NYN1355DDaly Trucking LLC · Paxton, NEN1356DApte John W · Biddeford, MEN1356HHatley Byron J · Sparks, NVN1357BHall Frederick R · Marana, AZN1357QMckenzie Paul · Stockton, CAN1357YHouse Robert L · Cleveland, GAFirst renewal noticeN13588Headley Thomas J · Aptos, CAN1358BBoyko Seth · Ruso, NDN1358QWilliams Matthew L · Longview, TXN1359DPribbenow John L · Anchorage, AKN135AUCoppice Aviation Assets LLC · Lewes, DEN135ETThiessen Elvin D · Butterfield, MNN135HMid Continent Aircraft Corp · Hayti, MON135JBMajane John A · Bethesda, MDN135JJSteinhausen Darrell · Torrington, WYN1360BMcmillian Custom Service Inc · Waynesboro, GAN1361DVasko Laszlo · Harvard, MAN1361FWorld Media Corp · Hialeah, FLN1361HWebb Randol B Jr · Sherman, CTN1361YFeathered Flyers LLC · Louisville, KYN13629Waters Richard G · Owens Cross Roads, ALN1362DGulf Elm Corp · Wilmington, DEN1362YKansas State University · Salina, KSFirst renewal noticeN1363HAsay Philip W · Anchorage, AKN1363QAsch John C · Zephyrhills, FLN1363YDrobnis Adam R · Dickson, TNN1364DSpiro Paul M · Anchorage, AKN1364FLewis David N · Carmel, INN1364KYager Stuart O · Wellington, KSN1365FHouse Conrad B · Hernando, MSN1365HConger Gary L · Oneida, WI
Back to AD 94-05-05 R1