AD 94-05-05 R1
Registered aircraft · 26,231
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.
N4172VMd Aero LLC · Somerton, AZN4173VLohmeier George A · Indianapolis, INN41741Funk Aeroplane Company · Basehor, KSN41754Lewis Mark E · Datil, NMN4175FGay Clayton B · Villisca, IAFirst renewal noticeN4175LColangelo Frank · New Preston, CTN4176EMacveigh Craig A · New Carlisle, OHN4176FKruggel Kurt · Rancho Cucamonga, CAN4176NElsberry Freddie L · Lake Jackson, TXN4177FWinkler Steve · Clarksburg, CAN4178EWest Michigan Aviation Inc · Kalamazoo, MIN4178VVan Dyke Robert L · Foley, ALN4179EBell Scott A · Mc Alpin, FLN4179LMorristown Flying Service Inc · Talbott, TNN4179NGauntt Stephen R · Kennewick, WAN4179UParks Daniel J · Milton, FLN4179VSchmidt David · Brooksville, MSN417JGRice Clifford H Sr · Natchitoches, LAN417YBWaddell Richard K · Loveland, CON4180CMckenney Bret · Billings, MTN4180EHesse Jeffry L · Talkeetna, AKN4180LMcginn Robert W · Marion, NCN4180UFirst Flight Aviators · Lincoln, ILN4181AJoye Robert M · Casa Grande, AZN4181EShooting Star Services LLC · Rosamond, CAN4181NDesrochers Robert F · Saint Johnsbury, VTFirst renewal noticeN4182EJones Jacob R · Rockford, TNN4182FHong Jason S · Yorba Linda, CAN4182VCoulter Robert Allen · Granger, INN4183FDurocher David T · Logan, UTFirst renewal noticeN4183HLazor Ronald E · Middlefield, CTN4184FCastle Jame R · Douglasville, GAN4184LKleman Connie F · West Bend, WIN4184UDoughton Jonathan S · Jefferson, ORN4185CRodgers Samuel D · Casper, WYN4185EHuffman Myron · Felda, FLN4185HColton F D · Canby, ORN4185NNew Daniel A · Deming, WAN4185UJennings William A · North Little Rock, ARN4185VHuff James L · Mars Hill, NCN4186LG2g Aviation LLC · Wray, CON4186VJohnson David E · Rock Island, ILN41889Bair Zach · Memphis, TNN4188FBayliss Warren E · Orlando, FLN4188LHlr Aviation LLC · Swan Lake, NYN4188NBascom Richard J Trustee · Elkhart, IAN4188U88 Uniform LLC · Jesup, GAN4188VNtn3n LLC · Titusville, FLN4189EJamieson Robert F · Friday Harbor, WAN4189VEastman Gregory L · Pueblo, CO
Back to AD 94-05-05 R1