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.
N56286Rigoni Terry N · Prescott, AZN56288Cole Douglas W · Kennewick, WAN56289Butler Stephen P · Ossian, INN5628FHobbs Jason · Saint Francisville, LAN5628HGade Dale Alan · Antioch, ILN5628PMiller Space A · Simi Valley, CAN5628SSchrier Timothy · Savage, MNN5628WB & D Aviators LLC · Bremen, INN56290Franscioni Farms Inc · Salinas, CAN56291Mccall Albert B II · Lebanon, TNN56294Sprague Roy W · Pie Town, NMN56298Breffeilh Robert A · Juneau, AKN5629NDusaint Jonathan E · Bishop, CAN5629PVick Josh K · Brentwood, TNN5629WLawrence Michael · Eden Prairie, MNN562ABNavigation Leasing LLC · Castle Rock, CON562ACN91934 LLC · Evergreen, CON562AEL-Bird LLC · Hood River, ORN562AFMustang Sally Aviation LLC · Camden, SCN562AGSkywest Leasing Inc · St George, UTN562BAAviation Financial Corp · Torrance, CAN562CBKqm Aviation · Bristow, VAN562FElite Approach LLC · Chesterfield, MON562MAMorrison Richard L Trustee · Canyon Lake, TXN562MMStarworld International Ltd · Long Beach, CAN562NDSpartan Education LLC · Tulsa, OKN562PUSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedN562PWWaters Peter M · Baltimore, MDN562TSumner Properties LLC · Somersworth, NHN562WTHawley William L · Moab, UTN56302Ginther Michael P · Orange Township, NDN56304Registered aircraftN56307Cjs Envol LLC · Rowayton, CTN56309Des Jardins Richard T · St Joseph, MIN5630DRegistered aircraftN5630NLeve Robert M · Canton, CTN5630PWick Eric J · Three Lakes, WIN5630VMccardle Aviation LLC · Kalispell, MTN56310Kudlacek Ondrej · Lavon, TXN56313Markel John E · Sussex, NJN56315Registered aircraftN56317Flying Doctor LLC · Clearwater, FLN5631EN141ns LLC · Lantana, FLN5631HBoyd Cecil E · Chocowinity, NCN5631LKing Michael Wayne · Centreville, MDN5631PNeal Brian C · Monrovia, CAN5631QBayette Andrew · Calhan, CON5631UTejada Emilia P · Oakland Park, FLN5631ZMooney Timothy · Hedgesville, WVN56320Merry Peter · Franklin, TN
Back to AD 81-18-04 R2