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.
N5425WIrmen Walter Michael Jr · Arlington Heights, ILN5425YWilson Leif L · Tok, AKN5426Vieira Mark · Turlock, CAN54266Low Country Skyways LLC · Wilmington, DEN5426FPressley Aviation LLC · New London, NCN5426JMedia Stew LLC · Carson City, NVN5426MWorthington Aras · Anchorage, AKN5426QLen Emery Photography LLC · Springfield, VTN54273Swanson Gary A · Fort Bragg, CAN5427FRebel Aviation Inc · Liberty, MON5427ZRegistration Pending · Dothan, ALRegistration pendingN54283Sale Reported · Lewistown, MTSale reportedN54285Monahan Richard J Jr · Budd Lake, NJN54288Chandler Air Service Inc · Chandler, AZN5428FSchold Maury W · Stafford Springs, CTN5428KTomlin Rollin D · Wilmington, OHN5428LMacair Aviation LLC · Xenia, OHN5428WBon Investment Holdings LLC · Zephyrhills, FLN54290Laguna Verde Leasing Inc · Wilmington, DEN54291Flight School Of Gwinnett Inc · Lawrenceville, GAN54296Honcho Aircraft LLC · Crosby, TXN5429FQuick Kenneth C Jr · Burke, VAN5429LGardner T Larry · Dickson, TNN5429WLafontaine Generator Exchange Inc · La Fontaine, INN542APa28 Aircraft LLC · Wilmington, DEN542CWCentral Washington University · Ellensburg, WAN542EClegg Edward T · Standish, MEN542EZLesher Caleb J · Cottonwood, CAN542FCooper Nina · Lake Elmo, MNN542FLHaffey George F · Fernandina Beach, FLN542GAtlantic Helicopters International Inc · Lewes, DENon-citizen corporation, flight hours not reportedN542HGraham Jack D · Hamilton, TXN542HFPars Avn Corp · Wilmington, DEN542JPGrauer Keaton · Marysville, KSN542JVBeaubien Matthew L · Sacramento, CAN542KAtp Aircraft 3 LLC · Wilmington, DEN542LHarvey Matthew T · Aiken, SCN542MADaystar Aviation LLC · Orange Park, FLN542MJRegistration Pending · Helena, MTRegistration pendingN542PUNewbridge Unlimited LLC · Sunny Isles Beach, FLN542RTVerkaik Michael S · Oakdale, CAN5430Plowman Arnold H · Willmar, MNN54306Aiken Patrick J · West Greenwich, RIN5430FUnion Aviation LLC · El Dorado, ARN5430LKanarick Justin · Colleyville, TXN5430MAmi Aviation Inc · Monroe, NYN5430WAnderson Douglas S · Gansevoort, NYN5431Reynolds Stuart N II · Sutherland, VAN54311Daniel Earl F · Ashland, KYN54319Jones Roddy H · Thomasville, GA
Back to AD 90-04-06 R1