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.
N790HMMota Hector · Miramar, FLN790LLetourneau University · Longview, TXN790MAKappen Specialty Services LLC · Cass City, MIN790NDUnd Aerospace Foundation · Grand Forks, NDN790PRMoody William J · Port Angeles, WAN790SATavern Aviation LLC · Tavernier, FLN790SHMichael Mollere Inc · Marion, TXN790SPMustang Sally Aviation LLC · Camden, SCN790UBoard Of Regents Of The University Of Oklahoma · Norman, OKN790YNostra Aeris LLC · Midway, ARN790YAB & T Aviators Inc · Wantagh, NYN79102Van Wert County Regional Airport Aurthoirty · Van Wert, OHN79104Roman Nose Flying Club Inc · Newalla, OKN79105Linn Nicholas D · Norfolk, NEN7910GBrusse Leslie W · Enterprise, ALN7910PStanford Richard E · Oklahoma City, OKN79113Executive Flight Institute LLC · Murrieta, CAN79118Osceola Aerosport LLC · Osceola, WIN79119Carr Randal J · Chandler, OKN7911LAlthouse Randy A · Postville, IAN7911NRynearson Mark J · Wolcott, NYN7911WSandidge Richard A · Pueblo, CON79122Johnson John C · Squaw Valley, CAN79125Brekhus Palmer A · Tolley, NDN79126Grounded Hangar Inc · Turlock, CAN7912LMiller Cameron · Loomis, CAN79130M&M Shipshape LLC · Kalispell, MTN79133Rotate LLC · Eden Prairie, MNN79136Registered aircraftN79137Marshall Jeffery K · Pleasanton, CAN79139Manifee Doris Darlene · Black Canyon City, AZN7913NStamps David R · Sparta, TNN7913WStream Aviation LLC · Luther, OKN79142Nelson Tyler J · Hermantown, MNN79144Card Kevin R · Ormond Beach, FLN79145Hillestad Darrell L · Aberdeen, SDN79146Deguzman Arien L · Tomball, TXN79147Donnelly Jennifer A · Hackettstown, NJN7914GKai Aviation LLC · San Jose, CAN7914HJamrock Leasing LLC · Schenectady, NYN7914LHumble Aviation LLC · Russellville, ARN7914NTeeters Gregory R · Bossier City, LAN7914PBethers James D · Montpelier, IDN7914WInstrument Trainer Flying Club Inc · Champaign, ILN79150Registration Pending · Newark, DERegistration pendingN79155Donnelly Thomas E · Salome, AZN79159Lehn James M · Park Rapids, MNN7915HHanna Bay Holdings LLC · Hayward, WIN7915YTurbine Financial Group LLC · Ogden, UTN79162Fink Roland Jr · Berlin, MD
Back to AD 81-18-04 R2