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.
N587TPPockrus Pat B · Mineral Wells, TXN587WPLindner James F · Williamsburg, MIN5880ENashville Skyscrapers LLC · Old Hickory, TNN5880QSeely Scott · Edmond, OKN5880WDurkin Michael T · Sunland, CAN5881DKanooth Michael L · Washougal, WAN5881HGazda Jerry V · Granbury, TXN5881URegistered aircraftN5882FGo Fly Mi LLC · Saginaw, MIN5882LBreazeale Peter · Orangeburg, SCN5882PEvans Gene · Henderson, TXN5882QBean Merton H III · Phoenix, AZN5882UMartinez Guillermo E · Upland, CAN5883LOst Kenneth Alan · Langhorne, PAN5883QSnyder Stephen L · Lebanon, TNN5883ZMckernan Thomas H · Gabriels, NYN5884DMcmahan Johnny W · Gakona, AKN5884QOasis Aero Inc · Willmar, MNN5884UB & R Aircraft LLC · Wadsworth, OHN5885DConatser Shawn C · Fairbanks, AKN5885PCostanzo Christopher P · Staten Island, NYN5885ZLewis Vincent E · Oregon, MON5886DAg Solutions Of West Texas LLC · Roby, TXN5886FBacktoeden LLC · Casper, WYN5886H86h LLC · Burlington, VTN5886LCook Charles N · Lakeside, TXN5886PAce Aeromotive Inc · Miami, FLN5886XPeak Investments LLC · Roanoke, VAN5886ZArgabright Jeremy E · Bloomfield, MTN5887DBragdon James O · Monticello, FLN5887UFretz Richard G · Harrisburg, PAN5888HGfeller Kent · Winona, KSN5888PRegistered aircraftN5888QCross The Line Sales Inc · Lexington, NCN5888ULynch Francis X · Dumont, NJN5888ZGoldberg David C · Garner, NCN5889L100 Rads Corporation · Omaha, NEN5889RPatkotak Crawford A · Barrow, AKN5889VRegistration Pending · Cherry Hill, NJRegistration pendingN5889WHarrison Joshua · Canyon Country, CAN588BCSamela Nicholas V · Thomaston, CTN588DSCox Joshua · Ormond Beach, FLN588LAPiper 3 LLC · Chestnut Ridge, NYN588LESmith Jason E · Calliham, TXN588NDChristiansen Aviation LLC · Wilmington, DEN588TEJefferts Steven R · Longmont, CON5890DCouey Robert H · Anchorage, AKN5890LSturgeon Kenneth V · Winter Garden, FLN5890QDevils Lake Aero Repair Inc · Devils Lake, NDN5890UKempton Lana Julia Trustee · Douglasville, GA
Back to AD 90-04-06 R1