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.
N675DDRice Allen J · Steinhatchee, FLFirst renewal noticeN675EREmbry Riddle Aeronautical University Inc · Prescott, AZN675GMMeuer Gary · Tullahoma, TNN675JBRegistered aircraftN675JLLebechuck Kelly S · Murfreesboro, TNN675LHFf22 LLC · Scottsdale, AZN675MMDeane Steve P · Arlington, TXN675MPN9sa Corp Trustee · Wilmington, DEN675QFisher Global LLC · Conway, ARN675RFGoodson Danny R · Bristol, VAN675WMStoecklein Christine · Stanwood, WAN67601Aero Maintenance Inc · Vancouver, WAN6760BAnderson Michael N · Anchorage, AKN6760WBitter Loren Mark · Maricopa, AZN67611Kumor Ronald G · Casper, WYN67614Wampus Cats Inc · Davenport, IAN67618Hale Douglas W · Perryton, TXN6761UJaeger Howard E · Claremore, OKN6761WGirdley James Kevin · Taylorsville, KYN67624Hardman Lorin D · Wasilla, AKN6762BCarver Clarence K Trustee · Lutz, FLN6762NTaylor Norman A · Fayette, ALN6762WFox John M · Warrenville, ILN67638Blue Feathers Corp · Newark, DEN6763JMiddlestetter Matthew G · Green Cove Springs, FLN6763NRegistration Pending · Minden, NVRegistration pending, pending cancellationN6763PHeublein Eric C · Molalla, ORN67648Flying Vikings Inc · Hayward, CAN6764BMccollum Glen R Jr · Nikiski, AKN6764JZalik Michael A · San Francisco, CAN6764NBiermann William W · Hollister, CAN67651Salomonsson Mats · Fremont, CAN67652Final Design Group LLC · Hurricane, UTN67657Jade Air LLC · San Pedro, CAN6765NBogdan Joseph H · Soper, OKN6765PJamison Ronnie L · Phoenix, AZN6765WKakoczki Robert J · White Cloud, MIN6766BRutland Norman L Jr · Birmingham, ALN6766NFoley Erik J · Henderson, NVN6766PStephens Christopher R · Upper Marlboro, MDN6767BHolseberg Aviation LLC · Ridgeville, SCN6767CSilverstein Devyn · Austin, TXN6767JLarson Wayne K · Amboy, CAN6767NEichhorn Tyler L · Paonia, CON6767VParmenter Micah J · Aurora, CON6768BKimmel Frank Stewart III · Greenwood, MSN6768FFallis Robert P · Keller, TXN6768JSuncoast Flight Training LLC · Sarasota, FLN6768NPorthouse Chris · Bellingham, MAN6768PKeenan John E · Saratoga, CA
Back to AD 81-18-04 R2