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.
N5495WWings Over Lake Norman LLC · Mooresville, NCN5495ZHayes Robert L · Chesapeake, VAN54960First Eclipse Ltd · Richmond, VAN54968Kangas Kevin L · Fairbanks, AKN5496HWilson Charles L · Seattle, WAN5496LRoda Richard H · Wakefield, RIN5496PStreetman Bryan Scott · Palm Coast, FLN5496WMaddux Dawayne E · Weeki Wachee, FLN5496YAmundson Nancy F · Chugiak, AKN54972Snider Scott E · Turner, MTN5497LCardelli Steve V · San Bruno, CAN5497SVerbovskiy Vitaliy Viktorovich · Clovis, NMN5497WJethro Charter Flights LLC · Jacksonville, NCN5497ZShira Daniel C · Homedale, IDN54983Jin Jin Aviation LLC · Anchorage, AKN5498HGulf Atlantic Airways Inc · Gainesville, FLN5498PC & J Ventures LLC · Center, CON5498WBas Part Sales LLC · Greeley, CON5498ZCunningham Florence Jean · Spokane Valley, WAN54990Hoffman Maurice M · Bowdle, SDN5499PLabelle Consulting Group Inc · OntarioN5499QCronce Charles Scott · Pacifica, CAN5499WVerchick Peter A · Jacksonville, FLN549ASouthern Illinois University · Murphysboro, ILN549ACWhitaker James C · Washington, NCN549BCMitchell Rosemary · Harbour IslandNon-citizen corporation, flight hours not reportedN549BKBarenfeld Marc F · Angels Camp, CAN549DMCallaghan Jerry R · El Paso, TXN549EREmbry-Riddle Aeronautical University Inc · Prescott, AZN549JTPas Aviation Inc · Modesto, CAN549LMRundall Tanner R · Cedar Park, TXN549MAHinkle Airspray Inc · Cavalier, NDN549NDSpartan Education LLC · Tulsa, OKN549RVDelzell David Wayne · Heath, TXN549SSullivan Walter E Jr · Speirit Lake, IDN549SCSpartan Education LLC · Tulsa, OKN549TSAggregate Material Services LLC · Van Nuys, CAN549WSBoraam Aviation Inc · Prospect Heights, ILN549ZWMartin Riley J · Talkeetna, AKN54AHD&L Leasing Montana LLC · Kalispell, MTN54AJDietz Daniel James · Springville, IAN54BCloud Nine Ventures LLC · Riverview, FLN54BAEmerald City Aircraft Leasing Inc · Port Orchard, WAN54BJJohns William L · Paola, KSN54BWWalker D B · Rougemont, NCN54CBCb Wings LLC · Eugene, ORFirst renewal noticeN54CSO'Shea James · West Grove, PAN54CTBrubaker Calvin · Midvale, UTN54DLMorris Samuel A · Prineville, ORN54ELCascade Air LLC · Trout Run, PA
Back to AD 81-18-04 R2