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.
N6086UStearman Air Tours Inc · Gatesville, NCN6086WPegasus Ir LLC · Miami, FLN6087LSundsmo Sheldon L · Adams, WIN6087PBrandner Paul D · Lake Tapps, WAN6087QTyson Michael A · Cupertino, CAN6087UN6087u LLC · Homestead, FLN6088DSale Reported · Langley, WASale reportedN6088LCollins Harold H · North Las Vegas, NVN6088QParker Justan · New Durham, NHN6088UPotter Timothy E · Murfreesboro, TNN60895Donald Williamson · Piedmont, SDN6089DHoyt William C · Trimble, MON6089FAmeriflyers Of Texas Inc · Addison, TXN6089KDelta State University · Cleveland, MSN6089MAirplanes And Helicopters Of Oregon LLC · Sisters, ORN6089PMichaelsen Richard P · Sanborn, NYN6089QMolnar Victor · Ballston Spa, NYN608ACBas Part Sales LLC · Greeley, CON608AMEnalas Corp · Bayonne, NJN608DMMartens Dennis · Vermillion, SDN608DSJoerithan & Mp Aviation LLC · Whittier, CAN608EAKingsky Flight Academy LLC · Lakeland, FLN608EREmbry-Riddle Aeronautical University Inc · Prescott, AZN608FAStratus Rr LLC · New Castle, DEN608FMSouth Bay International Flight Association Inc · Torrance, CAN608FTFlorida Institute Of Technology · Melbourne, FLN608GCareer Pilot Training LLC · Wilmington, DEN608LESimons Barry · Inverness, FLN608MABair Jay D · Ephrata, WAN608PTAzure Leasing LLC · Oakdale, PAN608SCovey John R · Amboy, MNN608SHNational Aircraft Leasing Corp · Greenville, DEN608TMMarijono Vendy · Charlotte, NCN6090BPlane Fun Inc Tr Trustee · Snellville, GAN6090DWoolard Wayne W · Bath, NCN6090FAmeriflyers Of Texas Inc · Addison, TXN6090LDarcor Inc · Hampstead, NCN6090PBasin Franchising LLC · Vernal, UTN6090VRoberts Jon J · Parker, CON6090XAstle James H · Saint John, KSN6091DMentone Flying Club · Rochester, INN6091FAmeriflyers Of Texas Inc · Addison, TXN6091LMartino John F · Kingston, NYN6091MGollobit Matthew W · Pierce, NEN6091QBridges Jeffrey Kemp · Cumming, GAN6091VJames Jay C · Mesa, AZN6092DTanner Flying Service Inc · Cortez, CON6092FJasper Aviation Inc · Jasper, ALN6092MSchmucker Daniel · Bryn Athyn, PAN6092VAir Venture LLC · Au Gres, MI
Back to AD 81-18-04 R2