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.
N610SHSeto Christopher · Seattle, WAN610TGroeneveld John · Maryland Heights, MON610TEEwing Tanner · Wooster, OHN610UBoard Of Regents Of The University Of Oklahoma · Norman, OKN610WMWilber Christian B · Waukesha, WIN6110AState Of Montana · Helena, MTN6110CLueck Taylor W · Wasilla, AKN6110LRegistered aircraftN6110WZimmerman David A · Memphis, TNN6110XVitale Matthew W · Lithia Springs, GAN6111DAdventure Flight LLC · Duchesne, UTN6111LHoard Ryan · Burley, IDN6111QAces High Aviation LLC · Long Beach, CAN6112JColeman Timothy Lynn · Port Charlotte, FLN6112LConley Roy L · Butler, MON6112PBurnett Jennifer · Palmer, AKN6112SHall Metal Corp · Fort Pierce, FLN6112WRoberts Jackie P · Bangs, TXN6113JOracle Aviation LLC · Omaha, NEN6113LBonilla Neftali H · Krum, TXN6113NKrabill Ronald D · Halsey, ORN6113RColorado Northwestern Community College · Rangely, CON6113VLegacy Lsa LLC · Plainview, TXN6113WMurray Brian C · Jonesboro, ARN6114NSabourin David R · Draper, UTN6114PCompton Mark E · Garfield, KYN6114SGoral William W · Redlands, CAN6114WGottschalk William R · Fort Atkinson, WIN6114YFlies Warren E · Mesa, AZN6115Woxof Corp · Wilmington, DEN6115DGeske Robert L · Enderlin, NDN6115LWhite David W · South Fulton, TNFirst renewal noticeN6115SGan Specialties Inc · Pocatello, IDN61160Hat Creek Holding Company LLC · Bellville, TXN6116JGlobal Technical Services Inc · Fort Worth, TXN6116WKlyder Thomas A · Inverness, FLN6117LFlight Tech Inc · Arlington, WAN6117MFayette Hawks Flying Club Inc · Somerville, TNN6117PFriesen Aiden · Grants Pass, ORN6117WRoesler Robert D · Gordonsville, VAN6118DAtkinson James A · Bouse, AZN6118FPlane Fun Inc Tr Trustee · Snellville, GAN6118PNovak Mark S · Dawson, NEN6118WPiekielek John L · Punxsutawney, PAN6119DMeyer Robert M · Lancaster, NYN6119L19lima LLC · Elkhart, INN6119PModisette Jeremy W · Baldwin, GAN611ALMaverick Management Montana LLC · Yarmouth Port, MAN611APDobry Robert S · Crescent City, FLN611BDClement Aviation Inc · Tea, SD
Back to AD 81-18-04 R2