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.
N5733UBerkshire Aviation Enterprises LLC · Great Barrington, MAN57343Arrow Plane Inc · Chapel Hill, NCN57346Cohen Meaghan M · Edgemere, MDN57347Burmaster Gary S · Rancho Murieta, CAN5734UPiepenbrink Stephen J · Wichita, KSN57350G F Aviation Inc · Miramar, FLN57352Dewalt Colt Aerospace LLC · Logan, OHN57353Registration Pending · Hollister, MORegistration pendingN57358Farnsworth Philo L Trustee · Dunes City, ORN5735PPlanecrazyd LLC · Portal, GAN5735QBeler Arnold Ray II · Redlands, CAN5735WMorahan Mark A · Sandusky, OHFirst renewal noticeN5735ZCrouch Michael G · Brazoria, TXN57360Ranuio Julie V · Ramona, CAN57361Janusz Mika · Phoenix, AZN57364Fit Fliers LLC · Worcester, MAN57369Fahmy Bishoy · Fraser, MIN5736HEdwards Stephen L Trustee · Wasilla, AKN5736QWard Troy · Odessa, TXN5736UWunder Bernard A · Lusby, MDN5736WTime Flyer LLC · Kalispell, MTN5736ZMiller Andy D · Marana, AZN57370Nj Aviation LLC · Forest, VAN57371Morgan H Owen · Windsor, CON57378Darling Darrin D · Palm Desert, CAN57379Faison Alphonso Trustee · Gardena, CAN5737QBross Stephen W · Burke, VAN5737UStebbins A C · Tacoma, WAN5737WUltimate Airparts LLC · Strasburg, VAN57383Dalley Robert C · Waldron, INN57385Victor Foxtrot LLC · Scott City, KSN57386Arair LLC · Kindred, NDN5738HWalker Scott E · Largo, FLN5738LRosche Henry III · Loveland, OHN5738QGuillen Gregorio J · Lopatcong, NJN5738UFlorida Time Building LLC · Port Saint Lucie, FLN5738WCherokee 38whiskey LLC · Charlotte, NCN57390Beyer Mark E · Towanda, KSN57394Mccombs Evan · Peyton, CON57395Zangs William J · Poplar Grove, ILN57399Aerobatic 8kcab Holdings LLC · Murchison, TXN5739DSmith James A · Lyle, WAN5739HRegistered aircraftN5739LMcgll Phil · Huntsville, ALN5739QMorell Timothy S · Lino Lakes, MNN5739WFeralova Erika H · Gresham, ORN573ATAtp Aircraft 3 LLC · Wilmington, DEN573CBMussell Lincoln D · Longview, TXN573ELStellaire Alliance LLC · Fort Worth, TXN573JAYale Companies LLC DBA · Fishers, IN
Back to AD 81-18-04 R2