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.
N66884Sea2ski Flying Club Inc · Anchorage, AKN66888Registered aircraftAssigned (import), pending cancellationN6688RFarley Clayton · Hanford, CAN6688WArkansas Air Expeditions And Instruction LLC · Greenbrier, ARN66898Registration Pending · Haines, AKRegistration pendingN6689PQuintero Noel · Fontana, CAN6689UStillman Troy C · Neenah, WIN6689WStoll Jared M · Burnt Hills, NYN668AMCenter Line Aviation Limited · Brookville, PAN668BNBelter Randolph K · Zachary, LAN668CSTom Wood Aviation · Fishers, INN668CWPrecision Air Inc · Anchorage, AKN668EREmbry-Riddle Aeronautical University Inc · Prescott, AZN668GWRholetter Wayne C · Westminster, SCN668LStarr Larry D · Gold Hill, NCN668MAJohnson Saquane · Sunderland, MDN668QUnruly Passengers LLC · Piedmont, SCN668RFSass Roland Falk · Beale Afb, CAN668RVForester James C · Trenton, GAN668SANorth Country Heli-Flight Inc · Wilmington, DEN668TMAlpha Helicopters LLC · Lewes, DEN66908Herman Timothy R · Presho, SDN6690DMiesko Martin A · Sprng Brk Twp, PAN6690JJones Michael A · Chateaugay, NYN6691LCoconut Adventures LLC · Lewes, DEN6691RSgt Land And Cattle Co LLC · Bennington, KSN6691USchleis Ralph F · Manitowoc, WIN6691WN6691w LLC · Nazareth, PAN6692ZCavanaugh Flying Service Inc · Minden, NEN66931Laguna Verde Leasing Inc · Wilmington, DEN6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CAN6693JOgrady Thomas · Franklin Square, NYN6693UShapiro Kier I · Oxnard, CAN66941Blue Mountain Airways LLC · Woodstock, GAN66946Sunrise Aviation Inc · Ormond Beach, FLN66948Kuriger Michael R · Santa Clarita, CAN6694EThunderbird Aviation LLC · Littleton, CON6694JStegemoller Adam Dean · Lewisville, TXN6694RRegistered aircraftN6694UWilson Larry · Campbellsville, KYN6694WKhan Mohammed Sabir K · Sugar Land, TXN66954Wings Over Texas Holdings LLC · Denton, TXN6695JMorgan Jonathan · East Troy, WIN6695MRegistration Pending · Sheridan, WYRegistration pendingN6695RKepner Charles M · Shepherd, MIN6695WMeyers Chris · Andrews, TXN6696JTattersall Stewart Trustee · Minden, NVN6696UAtkinson Matthew D · Theodore, ALN66970California Airways LLC · Hayward, CAN66971Meridian Airport Authority · Meridian, MS
Back to AD 81-18-04 R2