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.
N5750ZFaux George F 11 · Newcastle, MEN57515Peterson Dean · Gothenburg, NEN57517Du Aircraft Leasing · Green Bay, WIN57519L & L Flying Inc · Glen Allan, MSN5751EFlight Tech Inc · Arlington, WAN5751LWoodward Stephen · Fountain Hills, AZN5751PKrager Aviation LLC · Perry, UTN57522Baker Brad L · Salcha, AKN5752LLamas Frank A · Brackettville, TXN5752QJackson John E · Oak Harbor, WAN5752URiggin Flight Service · Madison, SDN57532N57532 LLC · Wasilla, AKN57534Sale Reported · Drake, NDSale reported, pending cancellationN5753FRauch Jack · San Rafael, CAN5753HLindberg Samuel L · Odebolt, IAN5753WRegistration Pending · Royse City, TXRegistration pendingN5753ZFereday Richard R · Mccall, IDN5754DRocca John · Box Elder, SDN5754ECox Charles C · Hood River, ORN5754FStorm Joseph K · Enumclaw, WAN5754HPiper Aviation Museum Foundation · Lock Haven, PAN5754QHamm Martin C · Southport, NCN5754UAuthement Michael Ray · Pecos, TXN5754VWeiser Steven Clark · Hutto, TXN5754ZKumley William A · Camarillo, CAN57550Freese Marc Alan · Fulda, MNN57555Norden Paul E · Anchorage, AKN5755DNathan Timothy A · Arnold, MDN5755HMccafferty Gerald F · Tumwater, WAN5755UKyzer Aviation Holdings LLC · Fort Mill, SCN5755VArnold Alan Dale · Glenwood Springs, CON5755WSchmidt Mia H · Van Nuys, CAN5755ZSkibinski James J · Senoia, GAN57562Sitter Timothy L · Anchorage, AKFirst renewal noticeN5756FStewart Larry E · Seymour, INN5756QDominguez Juan · Austin, TXN5756YLamascus Mark S · King City, CAN5757EFlex Air Inc · San Diego, CAN5757FWaletzko David L · Avon, MNN5757HWahlquist Andrew J · Honey Grove, TXN5757KRegistered aircraftN5757WN63e LLC · Fallon, NVN5758FTipnis Zachary Arjun · Troy, NYN5758JBatchelder Wesley · Palacios, TXN5758PBarr Michael J · Colorado Springs, CON5758QAviation Forza Inc · Pompano Beach, FLN5758VNelson Mike R · Philip, SDN5758ZColt 135 LLC · Lexington, NEN5759FGelnett Dean A · Lansdale, PAN5759PDemars Michael · California, MD
Back to AD 81-18-04 R2