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.
N30901Anderson Keith C · Puyallup, WAN3090NJohnson Scott · Milan, MIN3090VPinkepank James A · Peachtree City, GAN3090XSills Garry D · Malakoff, TXN30916Sowders Darwin G · Robinson, TXN3091ECw & D Investment Inc · Riverview, FLN3091JThrom Donald R · Parachute, CON3091NWesterinen John P · Mass City, MIN3091SRempala Jill E · Saint Peters, MON3091XConnolly Shawn P · Chicopee, MAN3092ARainey Dennis D · Altus, OKN30937Ohlsson Patricia · Port Orange, FLN3093ASantana Paul D · Mont Vernon, NHN3093SAdkins Dwain L · Sycamore, ILN3093UEfflandt Joseph E · Eagle, IDN3094EJowett David J · Odessa, MON3094NWarganich William J Jr · Gatlinburg, TNN3095AWaters Daniel J · Trion, GAN3095SCessna 3095s LLC · Colorado Springs, CON30960Stuart John R · Taylorsville, KYN3096JAero Foundation Inc · Ventura, CAN3096UDyer Gerald W · Arlington, TXN3097ADc Aero LLC · Ramona, CAN3097JFlat Lake Air LLC · Eagle River, AKN3097SDaj Holdings Inc · Wilmington, DEN3097XSmall James M · Carthage, INN3098AWillford George A · Waterville, OHN3098JDorman David L · Garfield, MNN3098UHogan Lee · Addison, ILN3098XAnnrich Corp · Mc Lean, NYN30995Kirk Kevin J · Pulaski, PAN3099AOlivieri Damian L · Monument, CON3099HJones Fredrick R · Lawrence, KSN3099JRegistered aircraftSale reported, pending cancellationN3099KNimmons Johnny F · Brookshire, TXN3099SDrury Claude R · Denton, TXN3099UCotter William P · Elkhart, KSN30BXWalker Duane W · Grifton, NCN30CGGoff Marwin E · Camp Verde, AZN30CKJackson Gary · Simms, TXN30DBBouchard Dean · Glendive, MTN30HCinquanta Daril F · Arvada, CON30JWLittle Colin J · Bidwell, OHN30LDPartlow David D Jr · Pahoa, HIN30MUOracle Aviation LLC · Omaha, NEN30RBMitchell John A · Freeport, ILN30RJBrookshire Joseph E · Erie, CON30TGCarter Jesse E · Milford, OHN31000Fahy Thomas E · Carabaset Vly, MEN31005France Miles D · Wasilla, AK
Back to AD 94-05-05 R1