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.
N737SVPage Flying Club Inc · Page, NDN737SXRoudebush Kevin L · Salem, ORN737SZPeres John Patrick · Portland, ORN737TCFlyboys Nevada LLC · Henderson, NVN737TDJarvis Jeffrey S · Portland, ORN737TEJohn P Kintzle LLC · Mount Prospect, ILN737TFThrifty Comercio Inc · Austin, TXN737TJStanislaus County Sheriffs Department · Modesto, CAN737TMLiberty Aviation LLC · Henderson, NVN737TQN737tq Aviation LLC · Sheridan, WYN737TXCalifornia In Nice Inc · San Jose, CAN737TYTexins Flying Club · Mckinney, TXN737TZNickell Alan L · Rigby, IDN737UAAlternate Air Inc · Seattle, WAN737UEHostler Susan L · Bradfordwoods, PAN737UFHeart Of Texas Aviation LLC · Troy, TXN737UKAlternate Air Inc · Seattle, WAN737ULMelbourne Flight Training LLC · Melbourne, FLN737URSky Warrior Flight Training LLC · Pensacola, FLN737UYFlycarolina LLC · Concord, NCN737VAMartin Dana J · Spicewood, TXN737VBDavis Gregory L · Williamsburg, NMN737VCN737vc LLC · Wilmington, DEN737VERev Jet LLC · Pflugerville, TXN737VFCompass Aviation Maintenance LLC · Shelby, NCN737VLAuthorized Health Insurance Inc · Fair Oaks, CAN737VNRedstone Arsenal Flying Activity · Redstone Arsenal, ALN737VSWalters Pujadas & Walker Pc · Ocilla, GAN737VVDorsey Terry R · Henderson, TXN737WAFlying Taco LLC · Fountain Inn, SCN737WCJ.R.P. Leasing Ltd · Carroll, IAN737WEWild Eagle Aviation LLC · Arvada, CON737WPAeroworks Productions LLC · Kenosha, WIN737WQHinote Holdings LLC · Saint Charles, MON737WRN737wr LLC · Jacksonville, FLN737WSBoeing Employees Flying Association · Renton, WAN737WTHillcrest Aircraft Co · Lewiston, IDN737WXWhorton Aviation LLC · Winder, GAN737XAFirst Eclipse Limited · Richmond, VAN737XEZia Sky LLC · Las Cruces, NMN737XFCasper Holdings Inc · New Castle, DEN737XMJ F P Inc · Ellsworth, MEN737XSUniversity Of Maryland Eastern Shore · Princess Anne, MDN737XTHeins Alfred Jr · Monticello, NYN737XURaynor Andrew C · Kingman, AZN737XWWeiss Gregory K · Colorado Springs, CON737XZBrown John P Jr · Winter Garden, FLN737YADuffys Aircraft Sales And Lsg Inc · Neillsville, WIN737YBBurke Donald T · Scranton, NDN737YEAeroventures Flying Club Inc · Lilburn, GA
Back to AD 90-04-06 R1