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.
N4271Mcmakin Kent E · Rockton, ILN42710N42710 LLC · Itta Bena, MSN4271JDouble P Creative LLC · Pleasanton, TXN4271TDieck Michael J · Fayetteville, NCN4271ZFelmlee Dusty R · Laurel, MTN4272HOwen Toy C · Anchorage, AKN4272JSkywagon Corp Inc · Miami Springs, FLN4272PHurn Jordan D · Olney, ILN4272ZLightning Leasing LLC · Anchorage, AKN4273HWooten William E Jr · Taft, TNN4273JMccreedy Nathan · College Station, TXN4273QSimmons Robert J · Justin, TXN4273ZHay Stax West · Eureka, NVN4274JUnlimited Ventures LLC · Bozeman, MTN4274QLjn Aircraft LLC · Jamestown, NYN4274ZJantzen & Jantzen Farming LLC · Madrid, NEN42756Baystate Aviation LLC · North Easton, MAN4275EAllison Larry J · Villa Rica, GAN4275JEden Aviation LLC · Benbrook, TXN4275MHicks Joseph O · Germanton, NCN4276HTailwind Aviation Inc · Wasilla, AKN4276JDever Jake P · Destin, FLN4276PNiec Steven M · Clio, MIN4276QOjdrovich George · Steamboat Springs, CON4276REchols Mark R · Diana, TXN4276TTippett James R · Brownsville, TNN4277MDykema Richard Kenneth · Soldotna, AKN4277QRawlins William David Sr · Martinez, GAN4277ZHart Lewis W · Rexburg, IDN42785Cornell Andrew S · Jordan, MNN42787Macair Aviation LLC · Xenia, OHN4278HWrigley David C · Anchorage, AKN4278LIron Compass Aviation LLC · Gallatin, TNN4278MOwen Mark · Clyde, TXN4278SChagnot Catherine J · Athens, OHN4278ZDevoe Ryder Keegan · Encinitas, CAN4279HDeal Glen K · Palmer, AKN4279JUS Flight Academy International Inc DBA · Post, TXN4279KHawkins Terry D · Conyers, GAN4279TLambert Arthur A · Pinckneyville, ILN4279ZSwiss John T · Anchorage, AKN427ACNoyes Shawn R · Hudson Oaks, TXN427ASOliver Leland E · Tucson, AZN427BPBest Kenneth M · Sullivan, ILN427BYRobinson Tracy R · Veneta, ORN427CPCivil Air Patrol Inc · Maxwell Afb, ALN427DKNelson Michael E · Gig Harbor, WAN427DPCharlie Alpha Inc · Calabasas, CAN427ERegistered aircraftN427EFIshii Thomas W · Roseville, CA
Back to AD 90-04-06 R1