AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N5543WTerpe Roberto Palomera · Sedro Woolley, WAN5543ZKiendl Philip R · Carabaset Vly, MEN55449Syracuse Flight School Inc · Syracuse, NYN5544KZollars Thomas B · Dallas, TXN5544LRegistration Pending · Troy, NYRegistration pendingN5544WMatlack Mark R · Saint Bonifacius, MNN5544ZBetween The Seams Inc · Locust Grove, GAN5545Javelo LLC · Ash Flat, ARN55450Conway Global LLC · Groom, TXN55452Schroeder William L · Sarasota, FLN55457Legend Air Lease LLC · Hurricane, UTN55458Challenger LLC · Amston, CTN5545BLundsted Andrew S · Taylor Falls, MNN5545KSchroder Bernd · Brownsville, CAN5545MMata Brian J · Sacramento, CAN5545QVan Wagner Paul A · Waterford, PAN5545UHewitt Robert J · Ringwood, NJN5545ZPiper Aviation Museum Foundation · Lock Haven, PAN55460Nish Aviation LLC · Concord, NCN5546JRegistration Pending · Danbury, CTRegistration pendingN5546KRegistration Pending · Port Saint Lucie, FLRegistration pendingN5546MMathias Mark R · Gnadenhutten, OHN5546QBrant Ryan L · Meyersdale, PAN5546RGorn Joel · Lawrence, MAN5546UWright Michael R · Bristol, FLN5546WThird Step 4 LLC · Gilbert, AZN55470Ebersole Wayne D · Fairfield, MTN5547QMooney 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, NCN5548UMorales Ramos Abdiel · Tucson, AZN5548ZJurgens Noel G · Mound City, KSFirst renewal noticeN55497Murphy David B · Germantown, MDN55498Burke Monte D · Dallas, TXN5549UFar From Cheap LLC · Wichita Falls, TXN5549WFons Wlliam M · Oconomowoc, WIN5549ZRegistration Pending · Bloomsburg, PARegistration pendingN554DDale Wes · Gainesville, GAN554DKRvest Management LLC · Boulder City, NVN554FLTomenyaero Inc · Florence, ORN554GLConcho Aviation LLC · Sterling City, TXN554HSouthworth Elizabeth A · Igo, CAN554JCCouch Kent E · Bend, OR
Back to AD 90-04-06 R1