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.
N9299SSky King Flying Club Inc · Jackson, OHN929AArcher Aero LLC · Wilmington, DEN929BMSuntops Aircraft Holding LLC · Lakeland, FLN929BYPorter Ronald A · Waco, TXN929CCInfinity Aviation LLC · Comstock, WIN929CEMeyer Jonathan · Douglas, WYN929CMCanyon West LLC · Amarillo, TXN929DFFanning Dale E · Chesapeake, VAN929DWGreen Bryan D · Brenham, TXN929ELPatterson Bryan J · Brooks, GAN929GSRegistered aircraftN929JARegistered aircraftN929JCBurris Wesley Jay II · Richmond, TXN929KKDavies Lincoln J · Oostburg, WIN929KSConway John R · Spring, TXN929LSFlying Tigers Flight School Ltd · Houston, TXN929PABird Acquisition LLC · Phoenix, AZN929PGN929pg LLC · Bethlehem, PAN929RVStafford Tech Inc · Rehoboth, MAN929SCSoloveda LLC · Cut Bank, MTN929SMAir Manos LLC · Mesa, AZN929TCMattern Daniel L · Howard, PAN929TEGilling Bert N · Kula, HIN929ZWZwink Brandon R · Fort Dodge, IAN92ABSchmitt Steven L · Princeton, ILN92AFGraben Dale · Collinsville, ALN92ARBixby Colleen M · Ellsworth, NEN92AVFlachs Christopher R · Kalamazoo, MIN92AZRegistered aircraftN92BASprott Robert L · Perkins, OKN92BCRobert Craig LLC · Wilmington, DEN92BHHeydorff Stephen F Trustee · Sierra Madre, CAN92BPJohnnie Wayne Painter Jr · Livingston, TXN92BRQuinn Kenneth V · Pearl City, ILN92CZBluebirdaero Inc · Magnolia, TXN92DADelory Dana E · Shoreacres, TXN92DBBroder Alan H · Port St Lucie, FLN92EEGw Aero LLC · Arnold, MDN92ETWeigel Andrew F · Elbow Lake, MNN92EXPartners Aviation LLC · Wilmington, DEN92FBBauer Aviation LLC · St Germain, WIN92FRGliem Robert E Jr · Eddystone, PAN92FSEastern Kentucky University · Richmond, KYN92GCWhitmore Martha · Terlingua, TXN92GKRatchford Herman Jr · Bessemer City, NCN92GLSmetzer James H · Round Rock, TXN92GRMarrero Teresa · Jayuya, PRN92HFHeritage Asset Leasing LLC · Ronkonkoma, NYN92HURobinson Larry D · Dewitt, ARN92HZTieder Sheldon D · Rhinebeck, NY
Back to AD 81-18-04 R2