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.
N6952BWesley Jerry A · Moorland, IAN6952CSnoz Inc · Sharon, MAN6952JLagimoniere Gregory · Jacksonville Beach, FLN6952KPoor Jeffrey L · Bettles, AKN6952RMelville Isaiah · Panama City, FLN6952UDuggan Edwin T · Franklin, MEFirst renewal noticeN6952WBeaver Milton H II · Palmer, AKN6953DLambert Hubert D Sr · Lincolnton, NCN6953QBrancefield John Lewis · Fort Mohave, AZN6953WScotting David R · Pipestone, MNN6954PJcav8 LLC · Cartersville, GAN6954QBalash Bryan J · Oldenburg, INN6954VGrubb Jefferson D · Chesapeake, VAN6955DGlover Thomas B · Marana, AZFirst renewal noticeN6956BBushplane Lab LLC · Wilderville, ORN6956JJuliet Sky LLC · Sioux City, IAN6956KEdwards Stephen L · Wasilla, AKN6956QStaab Robert J · Wantage, NJN6956RMorgan Richard D · Belton, TXN6956VAbney Timothy R · Crossett, ARN6957BVaughn James R · Winchester, KYN6957PHoran Edward · Wexford, PAN6957QWashburn Ronald G · Westfield, INN6957VKnoke Keith W · Litchfield Park, AZN6958HJewell Aviation Inc · Kennett, MON6958JAkin Enterprises Inc · Greensboro, GAN6958UVauclin Brady P · Shreveport, LAN6958VSale Reported · Austin, TXSale reportedN6958WPeck Michael S · Las Vegas, NVN695APiper Archer Three LLC · Wilmington, DEN695ACHodgson Daniel J · Anchorage, AKN695FParagon Flight Training Co · Fort Myers, FLN695FLPugh Daniel J · Omaha, NEN695LHJrnd Corp · Lewes, DEN695NDFly Gateway Aviation Institute · New Castle, DEN695PMSimonson Robert J · Cedar Crest, NMN695RAPhillips Robert M · Imperial, CAN6960HZiller Wayne Jr · Fairbury, ILN6960KTillman William L · Virginia Beach, VAN6960UWayne Brett M · Saint George, UTN6961BTrimmer Marvin E · Willow, AKN6961DOrtega David J · San Antonio, TXN6961QReed Billy B · Cabool, MON6961UMeservey Harley G · Portland, ORN6961VHunt David · Burlington, IAN6961WExpresstek LLC · Farmington, UTN6962JBores Scott J · Huron, OHN6962KBast William B · Fairbanks, AKN6962UGrey Scott A · Bluff City, TNN6962VRez Peter Trustee · Scottsdale, AZ
Back to AD 90-04-06 R1