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.
N476PWGorton Gregory A · Ballston Spa, NYN476RBWilson Ricky A · Santa Teresa, NMN476SMTail Slide Aviation LLC · Wilmington, DEN476SPChristiansen Aviation LLC · Wilmington, DEN476TCFlorida Flight Training Center Inc · Venice, FLN47700Indian River Flying Club Inc · Rockledge, FLN47702Braudis Russell P · Pittsburg, TXN47705Tidona Robert J · Berwyn, PAN47706Coast 2 Coast LLC · Pensacola, FLN4770ARobinson Evan · Pasadena, CAN4770FHamblen Scott · Tucson, AZN4770LIdol Joshua N · Boone, NCN47713Cornerstone Financial Enterprises LLC · Mesquite, NVN47714Bradford Matthew Corin · Murrieta, CAN47718Ap Midway Inc · Palos Hills, ILN47719Webb Bennie Kenneth · Fitzgerald, GAN4771JAsx Flight Services LLC · Ashland, WIN4771LHenderson Brian K · Redding, CAN47723Six Drew · Clinton, OHN4772EDrost Larry L · Charlevoix, MIN4772LValiair Lc Trustee · Casper, WYN4772RKimball Michael G · Placerville, CON47737N47737 Holdings LLC · Gonzales, LAN47738Coady Thomas J · Wausau, WIN4773APaul W Michael · Sprague, WAN4773LSilver Express Co DBA · Miami, FLN4773ZLockaby Jess · Smithville, TXN4774AJewett Robert A · Wasilla, AKN4774EZhao Dan · New York, NYN4774FIlmberger Stephen J · Bend, ORN4774JAlbin John B · Milan, MIN4774PCannan Aviation Inc · Georgetown, TXN4775DHetrick-Price Willow · Anchorage, AKN4775LWadkins Chris H · Plummer, IDN4775PRegistered aircraftN47767Capps Clinton Wyatt · Navasota, TXN47768Registered aircraftN4776EAlpha One Aviation LLC · Dunedin, FLN4776JKimbrough Paul E · Millcreek, UTN4776LHitt John C · Plano, TXN47773Walo Barry F · Cresson, TXN4777HMorey Airplane Co Inc · Middleton, WIN4777JHowell Michael A · Parsons, KSN4777LRoss Charles B · Anchorage, AKN4778EClemmons Flyers LLC · Green Cove Springs, FLN4778LGarrett Russell K · Hazen, NDN47791Schwartz John E · Ventura, CAN477ALSimply Living LLC · Fort Myers, FLN477AMSpicher Samuel C Jr · Groveland, FLN477BGParker Dennis A · Charlevoix, MI
Back to AD 90-04-06 R1