AD 90-04-06 R1
Registered aircraft · 68,369
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.
N1308BHopewell Jeffrey D · Temple, TXN1308CHahn Aviation Inc · Troy, OHN13093Multiflight II Inc · Lakeville, MNN13095Air Ally Asset Management LLC · Chisago City, MNN13096Flights Cool LLC · La Conner, WAN13099Steeber Pauline M · Mcmurray, PAN1309U129w Holdings LLC · Terlingua, TXN1309WSanford Mark J · Ithaca, NYN1309ZReady Aim Flyer LLC · New Castle, DEN130ACBilco Air LLC · Danville, ILN130BBHatfield Derik L · Mesa, AZN130BNJch Aviation LLC · Midlothian, TXN130BRWilcox Charles R · Discovery Bay, CAN130BYCabe Robert D · San Antonio, TXN130BZEvans Robert G · Choctaw, OKN130CFFlying C Leasing Ltd · Wilmington, DEN130DBRolfe Daniel W · Elsie, MIN130DGDixie Aviation LLC · Pelham, ALN130EOshinuga Anthony A · Valley Center, CAN130ERSale Reported · Freeburg, PASale reportedN130GWBruckner Peter J · Rochester, NHN130GYRobinson Stewart · San Jacinto, CAN130JMRegistration Pending · Tampa, FLRegistration pendingN130KWClemente Daniel L · Manheim, PAN130MMMighty Mike LLC · Maysville, KYN130PJLindholm Dow W · Masury, OHN130PMMccurry Terry D · Greenwood, SCN130RNPrewitt Blake S · Prescott, AZN130RRAllbritten Jeffrey P · Winder, GAN130SRLimitless Aviation And Adventures LLC · Tomball, TXN130TLynch Machining LLC · North Vernon, INN130THDelage Jeffrey R · Biddeford, MEN130TWAlkire Richard P · Dayton, OHN130VJ Bird Air Service LLC · Cheyenne, WYN130VUSwords Kyle · New Albany, MSN130WLBlake Larry Q · Cleveland, GAN130YSBuntin David P · Bethpage, TNN130YYMatejka Jeff · Maple, NCN130ZKrueger Mark A · Anchorage, AKN131Ekstrand Marshall · Lake Stevens, WAN13100Ruttenberg Barbara A · Lexington, KYN13101North Hollywood Optimist Club Youth · Van Nuys, CAN13104Erley Robert B · Kirkland, WAN13108Registered aircraftN13109Illinois Valley Flying Club · Peru, ILN1310JRock Nh Services LLC · Alpine, TXN1310KVector Aviation LLC · Mentor, OHN1310UPiper Aircraft Inc · Vero Beach, FLN13115Kkmjj LLC · South Lyon, MIN13117Mccullough James R · Newville, PA
Back to AD 90-04-06 R1