AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N500GDElizondo Ernesto · Laredo, TXN500GPEhg Flight LLC · Venice, CAN500JFXota LLC · Litchfield, ILN500SUOhio State University · Columbus, OHN500TFPine Bluff Police Department · Pine Bluff, ARN50100Best Bobby R · Goldsboro, NCN50106Walker Charles B · Angleton, TXN50108Gibbs Robert I · Ravenswood, WVN50110Coger Charles E · Huntsville, ARN50115Affordable Flight Time LLC · Eagle River, AKN50118Carver Alan H · Winder, GAN5011ABores Scott J · Huron, OHN5011UAtp Aircraft 2 LLC · Wilmington, DEN5011XPro Air LLC · Alexandria, LAN50131Kotval Matthew J · Milaca, MNN50132Dunaire LLC · Mechanicsburg, PAN50133Pilot Legal Funding Inc · Fresh Meadows, NYN50138Kalb Brian A · Mechanicsburg, OHN5013AReed Ted R · San Angelo, TXN5013RBarxbar Aviation LLC · Mesa, AZN50140Air Devices Company LLC · Alpena, MIN50146Aero Sceince International LLC · Martinez, GAN5014DHall Matthew A · Coeur D Alene, IDN5014RCooper Flying Inc · Lamesa, TXN50150Above All Aviation Inc · Santa Barbara, CAN50151Thums April M · Murfreesboro, TNN50155Haupricht Andy C · Sanford, NCN50156Humanic Thomas J · Columbus, OHN50160Morales-Escareno Rogelio · San Diego, CAN5016AMoore Wallace Frank · Mckinney, TXN5016DCain Arthur W · Kenilworth, NJRegistration revokedN50170Moroney Aviation LLC · Chugiak, AKN50171Evans Mark E · Heber Springs, ARN50177Dudley Lee B · Passadumkeag, MEN5017AMeixell David Matthew · Santa Maria, CAN5017DGraham Thomas V · San Rafael, CAN5017RR&R Leasing LLC · Fargo, NDN5017UBen Allen LLC · Wilmington, DEN50180Robbins Richard T · Ketchikan, AKN50181Debelius Enemark Peter C · Crawfordville, FLN50184Wietecha Jack · Millington, ILN50188Ryburn Michael D · Basehor, KSN5018ABadger Daniel J · Yellow Springs, OHN50193Folsom Gary A · Marianna, FLN50194Brouillette Jakob D · Daleville, ALN5019DNobel John C · Brandon, FLN5019ERegistration Pending · Wilbur, WARegistration pendingN501ACNka Inc · Wilmington, DEN501DSChilson Jacob Shane · Willits, CAN501ERVista Air Inc · Pacoima, CA
Back to AD 79-10-14 R1