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.
N5305HMarlatt Daniel L · Susanville, CAFirst renewal noticeN5305KJ M F And Associates Inc · Alexandria, VAN5305LStearns Simon K · Edwardsville, ILN5305VAmerican Academy Of Aeronautics Inc · Stanford, CAN53065Cherry Hill Aviation LLC · Freetown, INN53069Northwoods Air LLC · Orono, MEN5306EN5306e LLC · Ashburn, VAN5306HWroe Daniel C · Denton, MDN5306KMills Bradley W · Wichita Falls, TXN5306LRusch Steven A · Sequim, WAN5306RSheldon Scott H · Cohasset, MAN5306UAircraft Solutions Group LLC · Englewood, CON53073Zahnow Todd · Raub, NDN53077Megasky Holdings LLC · Charleston, SCN53078Proodian Kevin J · Wellington, FLN5307PDaniels Kevin · Bellingham, MAN5307WWiley James E · Peace Valley, MON53080Isaacs Christopher W · Advance, NCN53087Colorado North Western Community College · Rangely, CON53088Sangal Shiddhartha · Annandale, NJN5308LNelson John · Wichita, KSN5308PRegistered aircraftN5309HZeis Patrick J · Albany, MNN5309JRegistered aircraftRegistration pending, pending cancellationN5309LTexasflight3000 Holdings LLC · Crossroads, TXN5309ZNorth Central Aircraft Sales · Tioga, NDN530CACavalair LLC · San Francisco, CAN530CJMyers Russell S · Spangle, WAN530EZBaxter Matthew C · Renton, WAN530HSCti Aircraft Leasing LLC · Memphis, TNN530KWFogarty Stephen · Wasilla, AKN530LRRydberg Larry · Albuquerque, NMN530MCMagic Carpet LLC · Wilmington, DEN530RFSale Reported · New Harmony, UTSale reportedN530RGCase Bruce E · Boynton Beach, FLN530SJGibson James · Ormond Beach, FLN530TSMetzger Mark · Peachtree City, GAN530TWKlos Keith L · Holmen, WIN530WBDmb Aircraft Inc · Wilmington, DEN53103Top Flight Aerial Photography LLC · Georgetown, TXN53107Pea-Wayman Flight LLC · Daytona Beach, FLN53108Prindle Steven G · Seaford, DEN5310DD & S Aviation LLC · Spring, TXN5310H426th Aero Squadron LLC · Cropwell, ALN5310WZientara Jim A · Zephyrhills, FLN5310ZStoller Russell L · Algoma, WIN5311Dykes William F · Laurel, MSN5311LKitko Stephen D · Bellefonte, PAN5311TSchrier Timothy M · Savage, MNN5311WBts Inc · Seattle, WA
Back to AD 90-04-06 R1