AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7735BEvergreen Investments LLC · Big Lake, AKN7735DSmith Aviation LLC · Springer, OKN7735NMelanson Wayne L · Liberal, KSN7735ZRonald W Gray DBA · Hooker, OKN7736CSt Pete Aviation Services LLC · Saint Petersburg, FLN7736GKnudson Aviation LLC · Bozeman, MTN7736LSimmons David · Fremont, NEN7736PJmj Aviation LLC · Kalispell, MTN7737DRinker Kraig G · Winlock, WAN7737JVir Inc · West Bend, WIN7737NKoch Michael R · Nemo, SDN7737PFlying Ankers LLC · Saint Marys, OHN7737TBrackett Lawrence J Jr · Midlothian, TXN7737WGt Air LLC · Burton, OHN7738GCurioso Enrique Martin · Irvine, CAFirst renewal noticeN7738JAzuyak Tony Jr · Kodiak, AKN7738KGallagher William James · Chalfont, PAN7738NBluegrass Aviation LLC · Springdale, ARN7738WFlying Turtle Management LLC · Ellicott City, MDN7738YAristizabal Leonardo · Van Nuys, CAN77396Galindo Don Ronald Jr · Walnut Grove, CAN7739GFlyguys 172 LLC · Liberty, NCN7739NSenia John A · Berlin, CTN7739PBloom James R · Port Matilda, PAN773AAAlf Ix LLC · Chicago, ILN773ACDuke Anthony Jr · Alvin, TXN773AKKlausler Andrew T · New Market, MNN773BAMustang Sally Aviation LLC · Camden, SCN773DBLivingston Jon B Trustee · San Marcos, CAN773GCareer Pilot Training LLC · Wilmington, DEN773HDWare Joseph B · Angleton, TXN773NDUniversity Of North Dakota · Grand Forks, NDN773RFLoper Scotty L · Midlothian, TXN773RVPearson Mark · Goodyear, AZN773SPFox Flying Club Inc · Wheaton, ILN773TFRivergates Ivy Aviation LLC · Boca Raton, FLN773TTTim Twisselman Enterprises Inc · San Luis Obispo, CAN773WGower Scott B · Shelbyville, KYN7740HDrum Danny R · Anchorage, AKN7740JEbm Management LLC · Canadian, TXN7740MMason Graham E · Olympia, WAN7740NLenderman Steven E · Sharpsburg, GAN7740UPiper Aircraft Inc · Vero Beach, FLN7740WReiger Roger L · Lafayette, INN7741DJacko Josh E · Anchorage, AKN7741GCaviness Dewayne · Chico, CAN7741JPiper Mac 3 LLC · Dover, DEN7741NBrindle Richard L · Pleasant Hall, PAN7741ZNorth Florida Soaring Society Inc · Jacksonville, FLN7742DSims Robert E · Richardson, TX
Back to AD 81-18-04 R2