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.
N761CAChristiansen Aviation LLC · Wilmington, DEN761CCHesston College Aviation · Hesston, KSN761CSParker Todd Steward · Kaysville, UTN761DAKing Air 76 LLC · Lewes, DEN761ESCronsell Kenneth L · Hampshire, ILN761FGWilliams Glenn D · Columbus, GAN761GGChocks Away Aviaton LLC · Redmond, ORN761GSSaulsbury Greg F · Nash, TXN761LAIowa Lakes Community College · Estherville, IAN761UAFirst Wings LLC · Sayre, PAN761WWilliams Richard G J · Labelle, FLN761YEUnique Educational Experiences Inc · Signal Hill, CAN7620FRed 5 LLC · Kalispell, MTFirst renewal noticeN7620GDc Aero LLC · Ramona, CAN7620HMckinney Leonard F · Anchorage, AKN7620KBarnes Thomas M · Pittsboro, NCN7620PSopwith James T · Sacramento, CAN7621GCrewdawg Aviation LLC · Concord, NCN7621SSmith Michael D · King George, VAN7621WAlexander Steven W · Kansas City, MON7622GBell Sky Pilots Inc · Reedley, CAN7622HEngler Eric M · Cass City, MIN7622JSkylink Aviation Inc · Florissant, MON7622KCooper Kristopher A · Hamersville, OHN7622LHowe Jamie W · Boynton Beach, FLN7622PGriffin Robert L Jr · Washington, NCN7622WBarnett Donald R · Atoka, TNN7623DBaker Donald A · Macedon, NYN7623GPlane Sane Aero LLC · Cary, NCN7623HCowan Drew Paul · Anchorage, AKN7623JWhite Jeffrey M · Carlsbad, CAN7623RAdamiak Jeffrey · Mount Laurel, NJN7623SKrejchik Daniel J · Portage, WIN7623VGove Richard · Riverside, CAFirst renewal noticeN7623WMidwest Heavy Construction LLC · Pleasant Hill, MON7624GAeroflight Flying Club Inc · Jackson, TNN7624JBriggano LLC · Mount Pleasant, SCN7624SHovey Gregg Beecher · San Diego, CAN7624WHartley Douglas R · Florence, ALN7625FHarbaugh Steven J · Riverside, CAN7625HCook Susan R · Carl Junction, MON7625JHuebscher Attila · Flemington, NJN7625MMccowan Kenneth L · Kansas City, KSN7625SN4457s LLC · Southport, NCN7625WWings Up LLC · Manteno, ILN7626FJamestown Jet Center Inc · Jamestown, NDN7626KTopp Audrey · Reno, NVN7626LLester Androcles J · Ester, AKN7626RBasinger Weston P · Alexandria, VAN7626WStiles Kenneth R · Ozawkie, KS
Back to AD 90-04-06 R1