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.
N5008PThree Chicks Aviation LLC · Benton, LAN5008TS E D Air LLC · Kimball, SDN5008WZanier Aldo M · Long Beach, CAN5009WRegistration Pending · Americus, GARegistration pendingN500AFAmerican Air Academy Inc · Merritt Island, FLN500BCGwinn Donald R · Mccall, IDN500BEAnders Robert · Deforest, WIN500BSCentral Aircraft Sales And Leasing LLC · Columbia, MON500BVCutbirth Henry Ray · Monahans, TXN500DDDecramer Richard J · Webster, MNN500DPO'Rourke Lawrence · Montgomery, PAN500DZEz Aviation LLC · Orlando, FLFirst renewal noticeN500FWWohltman Valerie A Trustee · Effingham, ILN500GCChenaille Lawrence A · Martinsville, INN500GDElizondo Ernesto · Laredo, TXN500GPEhg Flight LLC · Venice, CAN500GSCloud Chaser Aviation LLC · Chesnee, SCN500HKSegerstrom William C · Sunriver, ORN500HURower Gary · Brooks, GAN500JVRobinson Brian K · Bozeman, MTN500KCRuiz Edinson · Bakersfield, CAN500LHParis Air Inc · Vero Beach, FLN500LTSeeth Richard D · Yardville, NJN500MBBrown Mark R · Cotter, ARN500NAFive Star Marketing Inc · Raleigh, NCN500NPVolare Air LLC · Palm Harbor, FLN500TMcconnell Harold L · Cavalier, NDN500TEGovers Harald · Mesa, AZN500TFPine Bluff Police Department · Pine Bluff, ARN500VBParagon Airplane Leasing Co · Fort Myers, FLN500WSKns Asset Management LLC · Lumberton, TXN5010SAeroflyte LLC · Glastonbury, CTN5010TN5010t LLC · Arcadia, OKN5010WGayler Meredith M · Indio, CAN5010ZSchwagerman William C · Kingsville, MON5011Plane Fun Inc Tr Trustee · Snellville, GAN5011PFinkey Jason B · Leonidas, MIN5011ZHarders Justin · Cairo, NEN5012AEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeN5012MBig Bend Community College · Moses Lake, WAN5012NSouto Nathan J · Clearwater, FLN5012WAllen Michel D · Essex Jct, VTN5013RBarxbar Aviation LLC · Mesa, AZN5013SFlightworks LLC · North Myrtle Beach, SCN5013TDasilvafontoura Peterson · Santa Clarita, CAN5014PSky Valley Aviation LLC · Waverly, IAN5014ZHicks Francis · Elizabeth, PAN5015WCarman Christopher S · Iuka, MSN5015ZQuirk Charles Leo · Lake Charles, LAN5016SMccartan Gary · Pocahontas, IA
Back to AD 90-04-06 R1