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.
N8063CHigh Planes Aviation LLC · Goodland, KSN8063NDean Ralph G · Alfred, MEN8063VMiller Wade L · Roberts, MTN8063YGrant Alton C · Paris, TXN8063ZUS Helicopter Services Inc · Rochester Hills, MIN80641Missionary Flight Training Inc · Fort Pierce, FLN80643Santa Barbaara Flying Club · Goleta, CAN80645N80645 LLC · Rehoboth Beach, DEN8064RN8064r LLC · Kalispell, MTN8064WSled Aviation LLC · Prosper, TXN80657Shelburne Airport Inc · Shelburne, VTN8065CArrow Air LLC · Sioux Center, IAN8065HJehnes Jens W · Cocoa, FLN8065NSotelo Kaleb N · Visalia, CAN8065WGard Roger L · Danville, IAN8065YTipton Aero Shares LLC · Fort Meade, MDN80669Buchert Barbara K · Shrewsbury, MAN8066CSchachle Vernon E · Wasilla, AKN8066NSouthern Air Services LLC · Myakka City, FLN8066UBayphoto Helicopter LLC · Rehoboth Beach, DEN8066WWilson Jamal Abdul · White Plains, MDN80670Jb Aviation Management Inc · Wonder Lake, ILN80673Mitchell Aviation LLC · Mitchell, SDN80678Aero Maintenance Inc · Vancouver, WAN8067DBurgess Bruce A · Saint Johns, MIN8067GMaley Randy J · New Philadelphia, OHN8067NCsp Avionics LLC · Knoxville, TNN80684Domino Adam P · Saint Petersburg, FLN8068CThunderbird Aircraft Company · Bloomington, MNN8068GStructural Design And Analysis Inc · Reston, VAN8068JGo Vertical Aviation LLC · Russellville, ALN8068WRkd Flier Inc · Nemaha, IAN8068ZBasco John J · Pottstown, PAN80690Flight Foundation · Unicoi, TNN80692Registered aircraftN80697Moe-Air LLC · Cincinnati, OHN8069DCasey Michael B · Hemingford, NEN8069NRajski Douglas S · Freeburg, ILN8069WAdventures In The Sky Aviation LLC · Fresno, CAN806ATFlight School Of Texas LLC · Wilmington, DEN806BBNoyes Jimmy D · Fruitland, IDN806CWWilling John W · Grove City, OHN806DAPeak Leasing LLC · Anchorage, AKN806EHFisher Air LLC · Cardington, OHN806ERDiamond Aircraft Sales Of Kentucy LLC · Henderson, KYN806FTJohnson Daniel S · Louisville, KYN806GPPractical Educators Association · Amelia, VAN806HAFlywell Aviation LLC · Bowling Green, KYN806RVPastorek Jordan M · Frisco, TXN806SPAir Marion Inc · Marion, IN
Back to AD 90-04-06 R1