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.
N5680WGoines Courtnee J · Jacksonville, FLN5680YSchildberg Gregory M · Casey, IAN5681QSteixner Jessica M · Madison, TNN5681SHillcrest Aviation LLC · Midland, TXN5681VNewell & Sons · Roxboro, NCN5681ZCalvert Scott R · Pequannock, NJN56821Cowlin Aviation LLC · Houston, TXN56822Tanner Timothy S · Norton, KSN56823Fly Tu9 LLC · Vancouver, WAN56828Gillette Daniel R · Chillicothe, ILN5682LLahlum Steven R · Warroad, MNN5682QNagel Mildred J · Akron, OHN5682VSgm Contractors LLC · Great Falls, VAN5682WRiggin Flight Service Inc · Madison, SDN56831Burns Robert A · Fort Myers, FLFirst renewal noticeN56834Maslonka Bradley James · Prior Lake, MNN56836Spj Aviation Holdings LLC · Bentonville, ARN5683WYanta Chris · Rockport, TXN5683ZPalmenteri Louis · Rhome, TXN56847Nepsund Michael L · Park Rapids, MNN56849Macair Aviation LLC · Xenia, OHN5684PAce Drilling LLC · Johnson, KSN5684WSeverino Racli · Closter, NJN5684ZMuehlberg Stephen E · Newcastle, OKN56853Maxair Complex Flight LLC · Murfreesboro, TNN5685LFritz Frank M · Milwaukee, WIN5685PWalker Richard E · Quanah, TXN5685SGreen Taylor · Olympia, WAN5685UTres Amigos Flying Club LLC · Redding, CAN5685WRempel Steven P · Prague, OKN56860Horst Michael D · Chambersburg, PAN56861Wingsleasing LLC · Wichita, KSN56864Odom Joseph L Jr · Lake Mary, FLN5686LBresson Kyle M · Roxbury, CTN5686PGray Gary L · Frederick, OKN5686QBolton Nicolas · Murfreesboro, TNN5686UHobbs Stanley T · Middleburg, FLN5686WPromedical Inc · Pfafftown, NCN56874Styer David B · Pendleton, ORN5687LDedominici Kenneth · Vero Beach, FLN5687QRegistered aircraftN5687SRobbins Warren N · Chandler, AZN5687YBrouse Dan T · Magnolia, TXN56887Leavitt Teyvin M · Coeur D Alene, IDN56888Ameer & Zaki Aircraft Solutions LLC · Lewes, DEN56889Red Choochoo LLC · Madison, INN5688HSheradin Roland R · Cape Coral, FLN5688LDolan John C · Sequim, WAN5688STanneberg Larry · Coulee City, WAN5688TJoe Koch Construction Inc · Youngstown, OH
Back to AD 81-18-04 R2