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.
N3740JHersom Jeffrey T · Helena, MTN3740KWilliamson Ronald W · Westlake Village, CAN3740RRhodes Samuel R · Bonne Terre, MON3740SGarnsey Zene P · Schuylerville, NYN37412Alamo Liaison Group Inc · San Antonio, TXN3741FMclanahan John P · Culpeper, VAN3741JSharp Ruth · Clarksville, TNN3741KFratti Robert B · Nampa, IDN3741RAbecca Corp · Jackson, MIN37428Pietsch Kent D · Burlington, NDN3742JLow Cost Flying LLC · Chandler, AZN3742SHand Jerry A · Nacogdoches, TXN3742VPoppe David P · Nenana, AKN3743FRohde William B · Homer, NEFirst renewal noticeN3743LAero Flight Two LLC · Peoria, AZN3743VOmni Aero LLC · Wilkesboro, NCN3744LAir Jeffery LLC · Aledo, TXN3744VRegistration Pending · Madison, WVRegistration pendingN37451Hawley Luther S · Saint Matthews, SCN37453Parsons Lee E · Carrollton, OHN3745LMaxey Lonnie C · Powell, TNN3745RDodds Timothy E · Salmon, IDN3745SKondel Eugene F · Owosso, MIN3746JCrandall Lloyd G · Lake City, MIN3746LBygd Sherman O · New Richmond, WIN3746RPearson Eric · Wills Point, TXN3746VFritz Kurt M · Carson City, NVN3747Thieking Bruce H · Delta, CON3747JRegistration Pending · Bay Harbor Islands, FLRegistration pendingN3747LN3747l LLC · Sonora, CAN3747SToland Wesley H · Warrenton, ORN3747VBurick John C · Juneau, AKN3748FMcdonald David R · Duluth, MNN3748KDuffus Andrew · Renton, WAN3748RRotormate LLC · Royse City, TXN3748SGeminiair Inc · Davis, CAN3748VRowe Lindsey A · Apollo, PAN3749FLeduc Kramer LLC · Live Oak, FLN3749JLove Duane Anthony · San Rafael, CAFirst renewal noticeN3749KMorley Richard G · Indian Rocks Beach, FLN3749LWilcox James F · Garrison, NDN3749TRosario Ted · Sutter Creek, CAN3750FGrubbs Richard T · Spring, TXN3750JEagle East Aviation Inc · North Andover, MAN3750RN3750r LLC · Guthrie, OKN3750VNeal Latimer B IV · Fayetteville, GAN3751CLandry Kevin F · Saint Amant, LAFirst renewal noticeN3751VPeters Neil H · Britton, SDN3752FCopper River Airmotive LLC · Copper Center, AKN3752JLudwig Daniel C · New Rockford, ND
Back to AD 94-05-05 R1