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.
N8091COlson Christian A · Hayward, WIN8091DJohnston Zach H · Soldotna, AKN8091EChristiansen Aviation LLC · Wilmington, DEN8091GWood Kim W · Tucson, AZN8091RParis Air Inc · Vero Beach, FLN8091WClement Timothy S · Skidmore, MON8091XBlack Hunter F · Blanding, UTN8091YStevens Charles R · Williamsburg, MIN80921Conerly Group LLC · Denham Springs, LAN80926Flight Leasing Corp · Wilmington, DEN80928Bellingham Aviation Services LLC · Bellingham, WAN8092ERaleigh Flying Club LLC · Chapel Hill, NCN8092GEarly Stephen · Sharpsburg, GAN8092HUnited States Air Force Owner · Hanscom Afb, MAN8092NCash Management Consulting LLC · Granite Springs, NYN8092WDidea Aviation LLC · Orlando, FLN8092YStoks Gary R · Canby, MNN80931Augusta Aviation Inc · Augusta, GAN80934Cogelia Joseph M · Winchester, VAN80939Levin Joseph · Yukon, OKN8093DSmith Ihler M · Fairbanks, AKN8093GFargo Jet Center LLC · Fargo, NDN8093HSarraf Majid · Aliso Viejo, CAN8093NSaraland High School · Saraland, ALN80941Holombo Ray J · Taylors, SCN8094CPowell David J · Endicott, NYN8094DHigh Exposure Inc · Wilmington, DEN8094EHaas Robert F · Elbert, CON8094NEggan Mark A · Lee Center, NYN8094QSpitzer Helicopter LLC · Woodland Hills, CAN8094WMatney Tara · Abingdon, VAN8094YJamshidi Kourush · Kalamazoo, MIN80952Registered aircraftN80959Mets Flying Club Inc · Fairmount, INN8095CBryant Stephen C · Anchorage, AKN8095WSkierka Michael A · Browning, MTN8095YN8095y Inc · Oakdale, MNN80960Perry Robert Lawrence Trustee · Salinas, CAN80961A S Air LLC · Lantana, FLN80964Three Wing Flight School LLC · Stratford, CTN80968Wisconsin Aviation Inc · Watertown, WIN8096LRhinebeck Aerodrome Museum · Rhinebeck, NYN8096PTsacoyianis Jonathan J · Pascoag, RIN8096QHoover Charles J · Logansport, INN8096WRoberts Heather V · Birmingham, ALN80972Porter Timothy D · Saint Cloud, MNN80975N80975 LLC · Wilmington, DEN8097HMiloud Chadd K · Fort Worth, TXN8097JAjdari Rodmehr · Millville, NJN8097PEmery Jonathan D · Payson, AZ
Back to AD 90-04-06 R1