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.
N55270Mcconnell Jason A · Rose Hill, VAN55272Nienhuis Alvin Dale II · Brooksville, FLN55273Jcb Aircraft Sales & Leasing Inc · Belle Mead, NJN55275Bas Part Sales LLC · Greeley, CON55278Hackman Daniel W · Wimauma, FLN55279West Georgia Air Services · Lagrange, GAN5527FFarnie Christopher J · Jacksonville, FLN55284Winters Daniel K · Pennsburg, PAN55287Prairie Winds Aviation LLC · Overland Park, KSN5528KGates Steven S · Midlothian, TXN5528QCralle Family Aviation LLC · Midland, TXN5528RVroom Brian D · Tucson, AZN5528ZSmith Ryan M · Midland, TXN55291Riverside Flight Academy LLC · Riverside, CAN55299Trego/Dugan Aviation Of Grand Island Inc · Grand Island, NEN5529FKeiner Larry E · Drums, PAN5529KFloren Donald D · Royal City, WAN5529QWhipple Ron · Etna, CAN5529UStoll Travis · El Dorado Springs, MON5529WHarvey Gregory D Sr · Greenbush, MEN552ATHilliard Paul Kevin · Wichita, KSN552DMRedstone Aero LLC · Chesterfield, MON552GCArnold Loren Wesley · Marina Del Rey, CAN552KKing Monte L · Kerrville, TXN552KMPrecision Flying LLC · West Chester, OHN552LELeading Edge Flight Academy LLC · Bend, ORN552MDHillsboro Aero Academy LLC · Hillsboro, ORN552PCSaint Louis University · Saint Louis, MON552PUSkyborne Airline Academy Inc · Vero Beach, FLN552SPEngineers Flying Club Inc · Bethany, OKN55301Registered aircraftN55302Coastl Air Inc · Groton, CTN55303Cullum Phillip R Jr · San Tan Valley, AZN55304Brittle Aviation LLC · Chapel Hill, NCN55305Berry Mitchel R · Chatfield, MNN55306R & R Flying LLC · Miami, FLN5530WHobgood Sidney · Klamath Falls, ORN5530ZReeves Todd J · Mosier, ORN55310Monarch M Miller · Cloverport, KYN55311Aeras Transport LLC · Lewes, DEN55313Dunning Mark · Chino Hills, CAN55315Norman Eric Lee · Hilton Head Island, SCN55317Schwader Aviation LLC · Saint Joseph, MON55319Guckin Michael E · The Villages, FLN5531FSchmidt David D · Atlantic Mine, MIN5531HXin Han Aviation LLC · Atwater, CAN5531MPeterson Jay O · Las Vegas, NVN5531ZDarr Henry S · Drummond, MTN55320Dragon Flight Training Academy LLC · Pembroke Pines, FLN55325Hater Michael A · Cincinnati, OH
Back to AD 90-04-06 R1