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.
N4178HColomello Charles P · Tillson, NYN4178JBennett Jeffrey A · Southgate, MIN4178NK Tahoe Air LLC · Glendale, CAN4178XCarnes Alfred · Rome, GAN41790Coronel Noel R · Clifton, NJN41792Gwinner Flying Inc · Gwinner, NDN41797Valdes Eusebio · Miami, FLN41798Fried Dennis A · Selfridge, NDN4179BMitchell Matthew K · Cushing, OKN4179FJupiter Flight Service And Investing LLC · Lithonia, GAN4179QPhillips Cheryl A · Queenstown, MDN4179ZTnt Farms · Marana, AZN417ABHardin Gary E II · Farragut, TNN417CAHand David C · Oviedo, FLN417CBWings Over L A Aviation LLC · West Hills, CAN417CTGleaton Benjamin F · Waycross, GAN417CZHumphrey Scott C · Forney, TXN417DKVitrella Steven E · Melbourne, FLN417DMKcsi Aerial Patrol Inc · Bakersfield, CAN417EMManceaux Mike T · Mc Donald, TNN417EPEpic Aviation Inc · New Smyrna, FLFirst renewal noticeN417FLPorter Richard · Round Hill, VAN417FPUtah State University · Logan, UTN417GGPro Water Solutions LLC · Henderson, TXN417GPFurkin Custom Marine LLC DBA · Tompkinsville, KYN417HPKempt Neil H · Canyon Country, CAN417LLutes David W · Berryton, KSN417MCCollins Mark D · Signal Mountain, TNN417PABird Acquisition LLC · Phoenix, AZN417PRCullen Donald N · New Brockton, ALN417RTPender Bryan C · Rochester Hills, MIN417RVMiller Ira L · Yellville, ARN417SFLeonard Bruce D · Spokane, WAN417SPTonys Aerial Service Inc · Great Bend, KSN417WMAero Amusements LLC · Wildwood Crest, NJN417ZAlpha Tango Aircraft LLC · Wilmington, DEN41800Mccully Heather L · Payson, AZN41801Freeman James E · Dalworthington Gar, TXN41802Trs Holdings LLC · Kalispell, MTN41803Minot Aero Center · Minot, NDN41804Beulen Brian V · Mesa, AZFirst renewal noticeN41805Fosdick Kenneth E · Plymouth, MAN41807Reid Robert W DBA · Independence, ORN41808Noble Raymond D · East Windsor, CTN41809Britten Ben K · North Pole, AKN4180JThomason Todd · Harrison, ARN4180MFast Mover Aviation LLC · Fort Smith, ARN4180WHodson Bruce E · Madbury, NHN4180XJed Homes Inc · Lisbon, CTN4180ZSale Reported · Abilene, TXSale reported
Back to AD 90-04-06 R1