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.
N69GSDaphnee Moise Md Pa · Sarasota, FLN69HANorth County Flying LLC · North Palm Beach, FLN69HSPofahl Steven R · Brookings, SDN69HUMe Time LLC · Denver, CON69JBIsburgh Andrew N · Conyers, GAN69JCBlomquist Randall J · Cave Creek, AZN69JDPrivate Aero LLC · Sarasota, FLN69JTGranger Daphne · Pearland, TXN69JVRasch Hellmut G · Tomball, TXN69KCShipner Robert W · Palatine, ILN69KPBurns Justin J · Bend, ORN69KVNichols James D DBA · Williamson, GAN69KWWeeks Kermit A · Polk City, FLN69KYAircraft Guaranty Corp Trustee · Oklahoma City, OKN69LMMaynard Larry · Alpharetta, GAN69MGArizona Active Air LLC · Yuma, AZN69MJKerr Peter John H · North Charleston, SCN69MLArnold Thomas S · Saint Augustine, FLN69MWOlson James H · Eleva, WIN69NDShannon Christopher R · Nome, AKN69NNRoadrunner Contraptions LLC · Azle, TXN69PAWanagel Joshua · Berwyn, PAN69PZParagon Airplane Leasing Co · Fort Myers, FLN69RDKrens Janet E · Purcellville, VAN69RJSilver Blades Inc · Wilmington, DEN69RMDicicca Yolanda L · BitontoN69RNLeong Peng H · Sebastopol, CAN69RXFlying W Aviation LLC · Aurora, CON69SXShuck Michael W Trustee · Maize, KSN69TUD & G Aero LLC · Lomita, CAN69TWHiemstra Andrew · Tuolumne, CAN69TZUnder The Radar LLC · Henderson, NVN69ULRed Rock Flying School LLC · Mesa, AZN69VJLucida Group US LLC · Anchorage, AKN69VPPotts Vince L · Dothan, ALFirst renewal noticeN69WLPhillips Aviation · Port Orange, FLN69WREllis Dustin D · El Campo, TXN69WTKeyt Jeffrey D · New Providence, NJN69WZBost Jeffrey T · New London, NCN6ABCenterline Holdings Inc · Camden, DEN6ADBurchinal Issac Newton · Paris, TXN6AHHurlbut Arthur G · Canton, NYN6ALTelfeyan John · Little Compton, RIN6ASVazquez Jose E Torres · Vega Baja, PRN6BCBest John · Cave Creek, AZN6BEZephyr Enterprises Inc · Wilmington, DEN6BPSale Reported · Stockton, CASale reportedN6BQBeard Bradley A · Hanford, CAN6CFFalter Charles B · Cumberland, MDN6CGHarvey Benjamin A · Mountain View, CA
Back to AD 90-04-06 R1