AD 90-06-13
Registered aircraft · 1,826
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-06-13')
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-06-13')
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-06-13') 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-06-13') 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.
N1000EWr Hess Co · Oklahoma City, OKN100BZHartwell Holdings LLC · Dover, DEN100DSCascade Peaks Aviation LLC · Springfield, ORN100PYTbm Flying Lc · Pampa, TXN100SYAerodan Aviation LLC · Alpharetta, GAN100WPTads LLC · Kansas City, KSN100WTFranklin Creek Investments LLC · Theodore, ALN101JLLake Country Jet LLC · Waukesha, WIN101WYWyoming Department Of Transportation · Cheyenne, WYN1027JMagic Carpet LLC · Wilmington, DEN102DRCloud 9 LLC · Lafayette, LAN102HBBuzz-Air Of Indiana Inc · Michigan City, INN102VPPrioritylab LLC · Indianapolis, INN102WYWyoming Department Of Transportation · Cheyenne, WYN103BZJet Way LLC · Brooklyn, OHN103CWFlying Pigs LLC · Kinston, NCN103CXBonaire Aviation LLC · Vestavia Hills, ALN104VPJdlfox Transportation LLC · Missoula, MTN105BGC & K Aviation Services LLC · Wilmington, DEN105RHJem Aviation Solutions LLC · South River, NJN105TDJcd-Gp LLC · Center, TXN106PGGreco Equipment Leasing LLC · Bartlett, ILN106RHSouthern Bracing Systems Inc · Armuchee, GAN106SASkyline Aviation Services LLC · Miramar, FLN106SRSafari Intl LLC · Lewes, DEN106VPTeam Aero LLC · Shawnee, KSN107EEBlandco LLC · Greenville, SCN108ALRj Flight LLC · Saint Petersburg, FLN108VRDraughn Aviation LLC · Salado, TXN109DCFrog Force One LLC · Texico, NMN109GAFinancial Mistake Air LLC · Uvalda, GAN109JCL&F Aviation LLC · Dallas, TXN10EGJarcav LLC · The Woodlands, TXN10LYAir & Water Research Corp · Wilmington, DEN10TCGardner Aviation LLC · Hot Springs, ARN10TDPrairie Air LLC · Aberdeen, SDN10UHUniversity Of Alabama Board Of Trustees · Birmingham, ALN110GGo Soar LLC · Highland Village, TXN111AFWings Aloft Inc · Portland, ORN111FFabair LLC · Milwaukee, WIN111GJMalik Hassan · Richfield, OHN111LJSourek Trail Co Inc · Barberton, OHN111PVHenson Builders LLC · Dallas, TXN111SGAir Orlando Helicopters And Leasing · New Smyrna Beach, FLN111SSFamily Time Machine LLC · Stuart, FLN111YWN111yw LLC · Houston, TXN11288Fly The Coop Aviation LLC · Willow Park, TXN113USUnited Supermarkets LLC · Lubbock, TXN114KNKnc Flights LLC · Beaverton, ORN114VRSkyline Holdings LLC · Hailey, ID
Back to AD 90-06-13