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.
N55044Yale Aviation Inc · New Haven, CTN55049Spanier Sherri Kay · Belleview, FLN5504FWieselquist Kermit L · Westford, MAN5504KWhite Traci Michelle · Manasquan, NJN5504NWighs Terry L · Fairbanks, AKN5504PLanghorst Richard C · Waltham, MEN5504QDoll Electric Co Inc · Murphys, CAN5504SBoomer Aviation Inc · Fort Walton Beach, FLN5504WTaylor Deric C · Seguin, TXN5504YTarkington John W · Almyra, ARN55051Wings Over Texas Holdings LLC · Denton, TXN55055Martan LLC · Kansas City, MON55057Smooth Air LLC · Churubusco, INN55058Eggensberger Edmund G · Simpsonville, SCN5505FSerafinowicz Ronald P · Gilbert, AZN5505HKupferschmidt W Alan Trustee · Lake Elmo, MNN5505LRegistration Pending · Saint Johns, FLRegistration pendingN5505MCapozzi Eugene L · Kalispell, MTN5505NMargolies Lars · Goldens Bridge, NYN5505PLandmann Ryan J · Fort Walton Beach, FLN5505QReynolds C J · Cornelius, NCN5505UPaper Plane Aviation LLC · Avon Park, FLN5505WPerez Daniel E · Parsons, KSN55064Western Skyways Inc · Montrose, CON55065Lynch Timothy B · Aguadilla, PRN55066Premier Capital Enterprises LLC · Hurricane, UTN55067Hinsch Delano G · Larchwood, IAN55069Tre Aviation Corp · Wilmington, DEN5506CBattle Creek Powersports LLC · Jasper, TNN5506HWoods George M · Anchorage, AKN5506JSoaring For Christ LLC · Big Lake, AKN5506LKoster Michael Richard · Plano, TXN5506MCloud Kicker Aviation LLC · Kalamazoo, MIN5506UHumberto Moreno · Mulberry, FLN5506WMchatton Dret A · Redding, CAN5506ZOakcrest Management Inc · Brownsville, TXN55072Lorenzo John V · Tulare, CAN55075Paris Air Inc · Vero Beach, FLN55078Tiritilli Robert · Mission Viejo, CAN5507HAdair Caden S · Anchorage, AKN5507LFletcher Alex J · Weston, WIN5507PMccleskey Nicholas J · Mcminnville, ORN5507WBurnett Fred · Greenbrier, ARN55080Keath Brian S · Kansas City, MON55087Fosso Christopher M · Glendale, AZN5508JPaetzold Larry E · Brownwood, TXN5508LDe Lint Marcus W · Cove, ORN5508MLindvig Thomas H · Williston, NDN5508QSchmidt James A · Richmond, VAN5508WEkkel Bob J · Newaygo, MI
Back to AD 81-18-04 R2