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.
N70739Morey Airplane Co Inc · Middleton, WIN7073BHerman Seth J · Brookville, PAN7073GSky Warriors LLC · Hayward, CAN7073RMorris Gregory A · Arlington, TXN7073VOwen Greg · Ukiah, CAN7073WTjc Aviation Group LLC · Rolling Meadows, ILN7074KMayo Jesse J · Fairbanks, AKN7074RCl Finney Aviation LLC · Benton, KSN7074VRoyal J · Arlington, TXN7074YWsv Aero Inc · Wilmington, DEN7075GDraper Floyd L · El Paso, TXN7075QCorell Ryan J · Mason City, IAN7075RYoungs William R · Grand Blanc, MIN7076QAbbott Brett C · Leawood, KSN7077DPaden Guy T · Forestville, CAN7077JHarter James A · Centerville, OHN7077WMcclure Jared B · Claremore, OKN7078DScoggin Frank C · Wasilla, AKN7078RSeidel Electrical Services Inc · Salinas, CAN70798Yuba Sutter Aviation Inc · Olivehurst, CAN7079MArmstrong Bruce · Port Orchard, WAN7079RKoerner Aviation Inc · Kankakee, ILN7079VStrandberg Kevin L · Pennock, MNN707AAStahr John C · Weirsdale, FLN707ASCook Todd · South Solon, OHN707ATSpacely Space Sprockets LLC · Aurora, ORN707BCJagair LLC · Riceville, TNN707BDChadd Brian C · Nevada, MON707BFBradsher Harold M · Troy, MON707CGMohler Mark R · Green Cove Springs, FLN707DBBelk Dean E · Raleigh, NCN707DCBurgoon John R · Campbell, CAN707DJSun City Aviation LLC · Davie, FLN707DRRichardson Douglas · Goodlettsville, TNN707FTLong Kodi K · Wasilla, AKN707GDw Forensics LLC · Dallas, TXN707GAMorris David S · Henderson, NVN707GKSorby Steven R · Lyman, WAN707GLVoler Dans La Gloire LLC · Narberth, PAN707GSHillsboro Aero Academy LLC · Hillsboro, ORN707HCStewart Jacob D · Lake Dallas, TXN707JGRegistration Pending · North Andover, MARegistration pendingN707MFFeist Richard T · Emmett, IDN707PPattison Bradley D · Gig Harbor, WAN707PEPhoenix East Aviation LLC · Daytona Beach, FLN707PJScott Roberts · Florence, AZN707RMWilkes Jack M · Port Orchard, WAN707RRRudd David L · Asotin, WAN707RTRomeo Tango LLC · Indianapolis, INN707RVHier Steven P · Klamath Falls, OR
Back to AD 90-04-06 R1