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.
N66977Unique Educational Experiences · Signal Hill, CAN6697DAtlanta Aviation Academy Inc · Lawrenceville, GAN6697JGlenn Larry W · Bunn, NCN6697PTri County Air Courier LLC · Prosper, TXN6697RJ Bar Ranch LLC · Downey, IDN66985Reid Robert W III · Independence, ORN6698HNational Test Pilot School · Mojave, CAN6698QBrager Robert L · Oxnard, CAN6699Jcmc Inc · Junction City, KSN6699JRegistration Pending · Loup City, NERegistration pendingN6699LPierce Jeffrey D · Woodinville, WAN6699SBeach Coleen W · Moncks Corner, SCN6699UGuy Carlo A · Ramona, CAN669ALeppert James J · Dickey, NDN669AKRegistered aircraftN669AMForry Anthony · Athens, TNN669BCPhantom Holdings LLC · Lexington, NEN669CEOne Pft LLC · Denton, MTN669CPEmerald Isle Apartments LLC · Los Angeles, CAN669CRIrizarry Betsy M · Mayaguez, PRN669DKBrunner Matthew W · Bellingham, WAN669EREmbry-Riddle Aeronautical University Inc · Prescott, AZN669FGMustang Sally Aviation LLC · Camden, SCN669GBBernardi Gary R · New Cumberland, PAN669KPClink Andrew D · Phoenix, AZN669NEAcme Aircraft Flying Club LLC · Kalispell, MTN669PMKohl Rex · Eden Prairie, MNN669RVN669rv LLC · New Albany, INN669RWRhodes Brian W · Valdez, AKN669SHulick Kent · Houston, TXN669SMClearance Clarence Aviation LLC · Hallsville, TXN669SNKajans Douglas L · Reno, NVN669TJBouyea John M · Hillsboro, ORN669TMDirty Bird Helicopters LLC · Boerne, TXN669TWAlmanor Express LLC · Palo Alto, CAN669UShartle Austin W · Fredericksburg, PAN669WBBailey Donnie W Jr · Tyronza, ARN669XDiehl Steven K · Homestead, FLN66AALift Aviation LLC · Kingston, MAN66AJPalmer Paul H · Minden, LAN66AKDomke Daniel C · Fairbanks, AKN66ALXin Han Aviation LLC · Atwater, CAN66APPeterson Alex A · Ottertail, MNN66AUSky West Aviation Inc Trustee · Albuquerque, NMN66AWSg Aviation Inc · Clearwater, FLN66AZVia International Inc · Reunion, FLN66BHLj Air LLC · Ada, MIN66BRPierce Stephan L · Graham, TXN66CDKcsi Aerial Patrol Inc · Bakersfield, CAN66CFFuller Leonard C · Mattawa, WA
Back to AD 81-18-04 R2