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.
N5545PVouk Frank E · Firth, IDN5545QVan Wagner Paul A · Waterford, PAN5545SLareve Air LLC · Bloomfield, MIN5545TMoody Bible Institute Of Chicago · Spokane, WAN5545UHewitt Robert J · Ringwood, NJN5545ZPiper Aviation Museum Foundation · Lock Haven, PAN55460Nish Aviation LLC · Concord, NCN55462Riverside Pilots Inc · Riverside, CAN5546HMoore Thomas P · Basalt, CON5546JRegistration Pending · Danbury, CTRegistration pendingN5546KRegistration Pending · Port Saint Lucie, FLRegistration pendingN5546MMathias Mark R · Gnadenhutten, OHN5546PMowinski Frank R Jr · Ray, MIN5546QBrant Ryan L · Meyersdale, PAN5546RGorn Joel · Lawrence, MAN5546SChoice Vc LLC · Oakland, MIN5546UWright Michael R · Bristol, FLN5546WThird Step 4 LLC · Gilbert, AZN5546ZKooima John C · Rock Valley, IAN55470Ebersole Wayne D · Fairfield, MTN5547JWinds Aloft LLC · Huntsville, ALN5547QMooney N5547q LLC · Sacramento, CAN55482Crook Mark E · Elberton, GAN55483Edisto LLC · Falls City, NEN55484Yoder Sylvan R · Camilla, GAN55485Cross Gary DBA · Commerce Twp, MIN5548CBme&G Enterprises LLC · State College, PAN5548FMueller Albert · Brookfield, WIN5548HYoungs Erin M · Gillette, WYN5548LUnruly Passengers LLC · Piedmont, SCN5548QKlassic Rides LLC · Newton, NCN5548SGardner Timothy J · Gardnerville, NVN5548UMorales Ramos Abdiel · Tucson, AZN5548ZJurgens Noel G · Mound City, KSFirst renewal noticeN55497Murphy David B · Germantown, MDN55498Burke Monte D · Dallas, TXN5549JLombardi Steven · Edgewood, TXN5549NRfd Aero LLC · Wilsonville, ORN5549UFar From Cheap LLC · Wichita Falls, TXN5549WFons Wlliam M · Oconomowoc, WIN5549ZRegistration Pending · Bloomsburg, PARegistration pendingN554DDale Wes · Gainesville, GAN554DKRvest Management LLC · Boulder City, NVN554EREmbry-Riddle Aeronautical University Inc · Prescott, AZN554FLTomenyaero Inc · Florence, ORN554GLConcho Aviation LLC · Sterling City, TXN554HSouthworth Elizabeth A · Igo, CAN554JCCouch Kent E · Bend, ORN554LBSons Family Enterprises LLC · Wichita Falls, TXN554LHKretchmer Daniel R · Northfield, MN
Back to AD 81-18-04 R2