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.
N5145HFoust Michael L · Soldotna, AKN5145JDokulil Harry F Jr · Lowell, INN5145KZulu Jets LLC · Boerne, TXN5145SElsea Inc · Circleville, OHN5145XAnderson Aviation LLC · Hillsboro, NDN51467Ascent Aviation Inc · Van Nuys, CAN5146HTundra Aviation Inc · Casselton, NDN5146LCornell Flying Club Inc · Wheatfield, NYN5146PRenton Russell S · Whitestown, INN5146TMattson Randall · Richvale, CAN5146VFischer John W · Waukesha, WIN5146XChart-Airs LLC · West Terre Haute, INN5146ZBeloit Aviation LLC · Beloit, WIN51470Merryman Stephen R · Beach City, TXN5147EDirty Side Down LLC · Noblesville, INN5147HBeyond Willpower Inc · Shreveport, LAN5147KCline Aircraft LLC · Mena, ARN5147LPerkins David W · Newburgh, INN5147RKirkland Kerry G · Spring, TXN5147SBluegrass Aviation LLC · Clarksville, TNN5147UCox Coleman Haynie · Honea Path, SCN5147XBrown Russell J · Mahtomedi, MNN5148FBonura Rocco F Jr · Perkinston, MSN5148HMalad Aviation LLC · Bliss, IDN5148KHetteen David D · Camano Island, WAN5148PRegistered aircraftN5148SN7396w LLC · Coeymans Hollow, NYN5148TKloss Matthew Joseph · Rew, PAN5149EAce Of Spades Aviation LLC · Las Vegas, NVN5149HLeaders Bob O · Clear Lake, MNN5149LBaker Jon M · Eugene, ORN5149R5149r LLC · Manhattan, MTN5149SPiper Aircraft Inc · Vero Beach, FLN5149VAlcock Alan D · Empire, CAN5149WThomas Clifford C · Madisonville, TNN5149XAmboni Sinesio Jr · Wasilla, AKN5149ZWeishaar Wallace · Livingston, TXN514APa28 Aircraft LLC · Wilmington, DEN514CMoore Aviation Inc · Beaver Falls, PAN514CGFlight Training Aircraft LLC · Wilmington, DEN514DMHock Steven R · Indian Hills, CON514EEMeridian Aircraft LLC · Wilmington, DEN514FVenohr Robert E · Aurora, CON514FLLaurienzo Paul G · Portsmouth, RIN514JMCommercial Diving Inc · Melbourne, FLN514LLLenahan Lawrence M · Scottsdale, AZN514MCTurbo Aviation LLC · Chesterfield, SCN514MDPerez Pedro J · Mayaguez, PRN514MLPikes Private Planes LLC · Danville, KYN514MWWalker Michael L · Fredericksburg, TX
Back to AD 90-04-06 R1