AD 94-05-05 R1
Registered aircraft · 26,232
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.
N8214FHoneycutt David · Columbus, MSN8214UN8214u LLC · Sheridan, ARN8214XStroemsvik Kristian · Strasburg, VAN82150Houghton Robert E · North Ferrisburgh, VTN8215LUmphrey Reid · Douglasville, GAN8215XLaforest Jerome P · White Lake, MIN8216ADates Lauren C · Red Creek, NYN8216BBrezina Chad M · Whitewright, TXN8216ELevinson Taylor · Anchorage, AKN8216LWoodworth Mark S · Madison, OHN8216UClinch Jerome J · Lincoln, NEN8216XRiver Town Aviation LLC · Williamstown, WVN8217BRoll George N · Freeport, FLN8217LSteward Kim R · Durand, ILN8217XRiggs John · Punta Gorda, FLN8218FDel Rosario Jose · Hackettstown, NJN8218LTufts Kyle J · Hampden, MEN8218USalley Ronald C · Satellite Beach, FLN8218XEvans James · Millbrae, CAN82199Syverson Michael B · Waubun, MNN8219AElder Joel M · Scott City, KSN8219FKietzer Tyler L · Mankato, MNN8219UShaffer Kenneth H · Trout Lake, WAN8219VGreenman Lisa J · Chesterton, INN8219XCouch James T · Choctaw, OKN821RMC&C Aero LLC · Billings, MTN8220BTurner Travis Joseph · Chetek, WIN8220LFlywyo LLC · Kalispell, MTN8220SHammack Lindsey M · Westlake, TXN8220XGundry James A · Fall Creek, WIN82210Setzer Robert C Jr · Lakeland, FLN8221BMayberry Jonathan J · Lake Stevens, WAN8221FSale Reported · Eau Claire, MISale reportedN8221LAntholz John C · Apple Valley, MNN8222LSimpson Roger E Sr · Moncks Corner, SCN8222UCramer Bill · Oxnard, CAN8222XFoster Neal W · Nome, AKN8223ASmith Mathias N · Weiser, IDN8223FSoderman David W · Gilby, NDN8223LO'Connor Aidan J · East Moriches, NYN8223SRedditt William L · Erie, PAN8223UChapter 36 Flying Club Inc · Hagerstown, MDN8224ESudano Richard L · Cordova, AKN8224FDiamond David Z · Wrentham, MAN8224LCamp Lake Aircraft LLC · Salem Lakes, WIN8224TBeausoleil Randy L · Livingston, TXN8224UPlane Fun Inc Tr Trustee · Snellville, GAN82252Adams Jimmy P · Statesboro, GAFirst renewal noticeN8225BConner Mark Wes · Thomasville, NCN8225LWebb George Q · Monroe, GA
Back to AD 94-05-05 R1