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.
N4813ZStanley Daniel P · Kiowa, KSN4814CKingsky Flight Academy LLC · Lakeland, FLN4814DAir Puerto Rico Corp · Aguadilla, PRN4814LSingh Manjinder · Houston, TXN4814TRobertson Roland L · Meridian, IDN48156Perdue Ralph R Jr · Blacklick, OHN4815CSt Pete Aviation Services LLC · Saint Petersburg, FLN4815FAir 2 Sea LLC · Martin, TNN4815LSt Julian Randall R · Botkins, OHN4815TCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN4815ZRoberson James · Stephenville, TXN48167American Aviation Inc · Brooksville, FLN4816ASullivan Phillip M · Louisville, KYN4816LGodfrey John E · Greensboro, NCN4816TBulldog Air LLC · Wilmington, DEN4816VCollins Lisa A · Lake Dallas, TXN4817BPriority One Insurance & Investments Inc · Hillsboro, NDN4817TJoly Paul A · Henderson, NVN48187Nelson Lynn D · New Waverly, TXN4818ACampbell Allen G · Sault Sainte Marie, MIN4818DBald Eagle Flying Club · South Portland, MEN4818FCragg Philip A · Point Roberts, WAN4818LFischer Denise L · Lake View Terrace, CAN4818ZCornell Robert C · Lock Haven, PAN4819BSunrise Aviation Inc · Ormond Beach, FLN4819GVeer Aviation Tx LLC · Houston, TXN4819TJacob Rolando V · Las Vegas, NVN4819ZWest Coast Air Design LLC · Granada Hills, CAN481AArcher Aircraft LLC · Wilmington, DEN481ACVogel Lawrence O · Gig Harbor, WAN481CHHatch Craig R · Lake City, FLN481DMEdgewood Capital LLC · Joplin, MON481EMClark Jeffrey V · Libertyville, ILN481GSSchmidt Grant S · Jamestown, NDN481JLWolfco Timber Services LLC · Lebanon, ORN481MASlavens Timothy W · Howard City, MIN481WSBoer John W · Okeechobee, FLN481XCMarino Jerry C II · San Francisco, CAN48204Young Achilles Hsi-Jung · La Habra, CAN4820DBledsoe Duane C · Glendale, AZN4820FS&S Aviation Plus LLC · Greenville, ILN4820GAckerman Garry · Plano, TXN4820LFick Paul R · Deansboro, NYN4820ZPumford Thomas E Jr · Bannister, MIN4821AMeyer James D · Cheney, KSN4821FOestreich Klaus M · Needville, TXN4821LFlying Rocks LLC · Sparkill, NYN48222N1705r Inc · Cobb, CAN48228M & L Utility Contractors Inc · Cottondale, FLN4822ALybarger Michael L · Hot Springs, AR
Back to AD 90-04-06 R1