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.
N5431WBig Daddys Casino Inc · Huntington, WVN54322Myers Robert E · Sperry, OKN54324T2xb LLC · Valdosta, GAN5432EMilwaukee Aero LLC · Milwaukee, WIN5432HArmstrong Aviation Services LLC · Freeport, PAN5432LPlanesworld LLC · Jasper, GAN5432WVantilborg Craig S · Minot, NDN5432ZBellinger Ag Defense LLC · Manhattan, KSN5433David Lee Bradley Productions Inc · Temecula, CAN5433EAty Aviation Inc · Watertown, SDN5433LGray Sarah M · Boulder Creek, CAN5433PStephens Matthew T · Ocean Springs, MSN5433ZMouton Charles J Jr · Gladewater, TXN54346Aviation Trust Company LLC Trustee · Oklahoma City, OKN5434DSierra Lima Aviation LLC · Riverton, UTN5434EMiller Shane D · Cherokee, OKN54355Elizabeth City State University · Elizabeth City, NCN54357Rick Aviation Inc · Newport News, VAN5435EWings Over Texas Holdings LLC · Denton, TXN5435HWindham Brealon A · Kingsville, TXN5435WGabriel Juan J · Melbourne Beach, FLN5435ZEast Texas Aircraft Engines LLC · Palestine, TXN54360A S Flight Academy LLC · Lantana, FLN54364Parker Realty Co · Brunswick, GAN54369Don Warren D · Chandler, AZN5436EKitsap Aviation Squadron Inc · Southworth, WAN5436FTowle Willard M · Lompoc, CAN5436HTrue Course Air LLC · Rich Hill, MON5436ZHilgendorf Ross · Welcome, MNN54371Clare Air Services LLC · Saint Johns, MIN5437FLegacy Aviation LLC · Tea, SDN5437HBuena Vista Flying Club Inc · Richland Center, WIN5437JMiloud Chadd K · Fort Worth, TXN5437LRegistration Pending · Toquerville, UTRegistration pendingN5437PDeplorable Air LLC · Lakeland, FLN5437RSchafer Brian L · Carleton, MIN5437WRoutson David P · Dundee, MIN54381Paradise South Ventures LLC · Marco Island, FLN54384Above All Aviation Inc · Goleta, CAN54385Mattiello Scott C · Fernandina Beach, FLN5438WHoward Arthur L · Lake City, MNN54390Mcclelland Kip · Douglas, GAN54391Still Water Security Co LLC · Meriden, CTN54396Dicey Aviation LLC · Somerset, KYN54398Lashback Communications LLC · Farwell, MIN5439HMeyer Aviation Group LLC · Grand Island, NEN5439KEastern Kentucky University · Richmond, KYN5439LHasroun Andy · Sun Valley, CAN5439WRegistration Pending · Gary, SDRegistration pendingN5439ZCarbiener Ross E · Kewanee, IL
Back to AD 90-04-06 R1