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.
N6185HSargent Patrick S · Bicknell, INN6185JYankee Pilots Inc · Haverhill, MAN6185RSkywalker Ranch LLC · Dover, DEN61866Wings Over Texas Holdings LLC · Denton, TXN61868Jamm Aircraft LLC · Sterling, OHN6186JRegistration Pending · Sebastian, FLRegistration pendingN6186WWerren Carroll E · Concord, NHFirst renewal noticeN61870Dfu LLC · Boise, IDN61872Griffith William C III · Indianapolis, INN61873Umo Seneca LLC · Raleigh, NCN61875Knight Aviation I LLC · Prescott, AZN61876Ferrara James L Jr · Wellington, NVN61878Tate John M · Boonton, NJN61879Lake Elmo Aero LLC · Lake Elmo, MNN6187WAerospace Trust Management LLC Trustee · Wilmington, DEN61884Purfield Sara E · West Richland, WAN61889Registration Pending · Dallas, PARegistration pendingN6188JRaveesh Cn · Gladstone, MIN6188PFair Robert A · Bradford, PAN61890Stallion Leasing LLC · Louisville, KYN61891Higgins Jerome N · Oak Harbor, WAN61892Loughridge Robert M III · Prattville, ALN6189LKnutson Nathan J · Dubuque, IAN6189ZHall William B · Vincentown, NJN618ARoberts Jeffrey M · Markleville, INN618BSBauer Thomas G · Sturgeon Bay, WIN618DCrockett Brandon A · Hollis Center, MEN618DVVance Donn D · Monterey, TNN618EMMoffitt Michael E · Kent, IAN618FLDexter Development LLC · Kingfield, MEN618FTFlorida Institute Of Technology · Melbourne, FLN618JMaldonado Jose Ivan · Hahira, GAN618JKAiuto James J · Sterling Heights, MIN618JWMeriden Flyers LLC · Middlefield, CTN618KBCreech David W · Oriental, NCN618MJJuelfs Mark R · Faribault, MNN618MNEack Kenneth B · White Rock, NMN618NDUniversity Of North Dakota · Grand Forks, NDN618PMSieh Family LLC · Soldotna, AKN618RJDr Ghods Dmd Inc · Las Vegas, NVN618RLLynn Robert W · Independence, WVN618SWLang Marcus J · Hagatna, GUN618TMTuskegee Airmen National Historical Museum · Detroit, MIN618VMVan Eendenburg John · Bloomington, MNN61901Lalaguna Ricardo · Orlando, FLN6190DTap Solutions Inc · San Diego, CAN6190RSundance Flying Club Inc · Palo Alto, CAN6190WGrubenmann Ernst · Los Angeles, CAN61915Economy Flying Club Inc · Cusick, WAN6191DBrookway Aviation LLC · Brookhaven, MS
Back to AD 90-04-06 R1