AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N41822Kitchen Thomas M · Indiana, PAN41826Trull Stephen G · Golden Valley, MNN4182DBarnhart David H · San Antonio, TXN4182HAir Superiority Inc · Syracuse, NYN4182JBialecki Aviation Leasing LLC · Getzville, NYN4182LHorizon Dreams LLC · Homer, GAN4182SSassine Alain · Estero, FLN4182TMelbourne Flight Training LLC · Melbourne, FLN4182YShouling & Philip Enterprise · Lancaster, CAN4182ZKing Air Inc · Naknek, AKN41838Baker Arthur M II · Mundelein, ILN4183CLockhart Curtis M · Bay Village, OHN4183QSpurlock Daniel C · Harrogate, TNN4183ZTirrell Troy L · Cordova, AKN41842Robinson Helicopter Co · Torrance, CAN4184BWitt Aaron K · Hooker, OKN4184JGorman Jeffrey M · Ellensburg, WAN4184QBluesky Airline LLC · La Crescenta, CAN4184TMullys Equipment Leasing LLC · Castle Pines, CON4184VUpper Jets Maintenance LLC · Miami, FLN4184YMoncrief Rick L · Melba, IDN4184ZCross L Ranch Inc · Cohagen, MTN41858Skybound Aviation LLC · Kernersville, NCN41859Morale Joseph D · Dallas, TXN4185MRoom Nine LLC · Casper, WYN4185PFlying Woody LLC · Helena, MTN4185SJetset Aviation LLC · Helena, ALN4185WJames William S · Orange Park, FLN4185ZHill Leslie E · Patten, MEN41867Stevens Charles O · Columbus, MSN4186TRegistered aircraftN4186YCongdon Carl James · Manley Hot Springs, AKN4186ZSturgeon Ronald A · Anchorage, AKN4187JPeterson Erik J · Revillo, SDN4187SJ&S Aviation Services LLC · Hastings, NEN4187YStohr Beuford G · Woden, IAN4187ZPickus Norman F · Fairbanks, AKN41880Brown Terry K · Eddyville, IAN41882Monroe Robert E · Navarre, FLN41888Lanyi Clifford M · Attleboro, MAN4188JLaib Aaron B · Emporia, KSN4188PAero Club Valkaria LLC · Malabar, FLN4188SMajor Air LLC · Charleston, SCN4188TBird Acquisition LLC · Phoenix, AZN4188YSandberg Steven R · Malta, ILN4188ZDanielson Debra · Skillman, NJN41896Hoffman Rick · Buckley, WAN41897Unlimited Upside LLC · Boggstown, INN4189PAdams Carlos · Hawi, HIN4189SHigh Planes Holdings LLC · Lexington, NE
Back to AD 2007-04-19 R1