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.
N777CYMiller Shawn C · Milaca, MNN777DJMartin Dale A · Lewiston, IDN777DPArnold Vincent Craig · Rosharon, TXN777DTMcchristian Jerome M · Granbury, TXN777DUSc Infinities LLC · Dover, DEN777DVTharp Thomas J · Nampa, IDN777DWLawless Aviation LLC · Fishers, INN777ENSky West Aviation Inc Trustee · Albuquerque, NMN777ESD&J Aviation LLC · Gotha, FLN777EZInternational Aviation Group LLC · Lake Wales, FLN777FJStewart Michael W · Snellville, GAN777FSCasey William F · Ponderay, IDN777GC777gc Holdings LLC · Milford, CTN777GEAir Float One LLC · Stuart, FLN777HJBallantyne Benjamin J · South China, MEN777HVSkyline Air Tours LLC · Crown Point, INN777JRMiloud Chadd K · Fort Worth, TXN777KBGeisler Stephanie N · Inman, SCN777KGLonnevik Dennis F · Bigfork, MTN777KPKelly'S Flying Service LLC · Warrensburg, MON777LCSelover Stephan Holger A · Lake Oswego, ORN777LH7 Moon LLC · Albuquerque, NMN777LKMathena Gregory H · Guilford, INN777LTYates Deborah L · Pioneer, CAN777LYUmpqua Flying Organization LLC · Roseburg, ORN777MRRutherford Michael A · Medina, OHN777PWAerowest LLC · Independence, ORN777RHLarson Peter T Trustee · Coraopolis, PAN777SNichols Max E · Great Bend, KSN777SDBoomerang Air LLC · Cedar Park, TXN777SRWilkie David J · Nashua, NHN777SXSkinner Norman D · Osceola, IAN777TCCook Timothy · Byrdstown, TNN777TGWeder Erwin M · Sand Springs, MTN777TRBlack Vernon N · Hildale, UTN777UFTaylor Douglas M · Dallas, TXN777UHRobinson Helicopter Company Inc · Torrance, CAN777VAVolante Aircraft LLC · South Jordan, UTN777VCChaney Van G · Niceville, FLN777VLFirst Aerial Assault Inc · Williamston, NCN777VPFlightwing Equipment Corp · Beverly Hills, CAN777VXGutierrez Ruben E · Fontana, CAN777WBClark Lloyd E · Hanover, MDN7780DMathews Development Co Inc · Santa Rosa Beach, FLN7780GAero Quest LLC DBA · Olive Branch, MSN7780YKeller Zachary T · Wasilla, AKN7781CDrake Donald J · Rochester, NYN7781DCraig Adam J · Anchorage, AKN7781GKelley Aircraft LLC · Weyers Cave, VAN7781HMittelstadt Kevin J · Oakfield, WI
Back to AD 90-04-06 R1