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.
N5111GHammond Jason · Nevada City, CAN51124Kd Farms Inc · Cosmos, MNN51126Ostrander William P · Millerton, PAN5112DScootair LLC · Alburgh, VTN5112ETail Wheel Excursion LLC · Redmond, ORN5112GCrawford Law Pllc · Selah, WAN5112JDenslow Carl W · Barto, PAN5112NRcr Aviation LLC · Cave Creek, AZN51133Riegle Shannon D · Muncie, INN51134Jstream Lc · Sheridan, WYN51135Liberty Belle Aviation LLC · Vista, CAN51136St Denis Matthew · Mountlake Terrace, WAFirst renewal noticeN5113FVtf LLC · Winter Haven, FLN5113KParrillo Development And Real Estate LLC · Sarasota, FLN5113QTri-County Aviation LLC · Lawrenceburg, TNN51147Penn Mitchell · Poplar Bluff, MON5114DCasillas Justin M · Liberty, TXN5114EVinton John H · Mullen, NEN5114KParrillo Development And Real Estate LLC · Moorestown, NJN5114QJ&A Air · Richfield, UTN5114USilverhawk Aviation Academy LLC · Caldwell, IDN5114ZMustang Sally Aviation LLC · Camden, SCN51156Knutson Wayne R · Tioga, NDN5115BWateractive43 LLC · Auburn, CAN5115EBarak David T · Mountain Home, IDN5115FSunrise Equipment Co · Canton, OHN5115NFernandez Arriaga Emilio · Miami, FLN51162Raia James · Vero Beach, FLN51163Christiansen Aviation LLC · Wilmington, DEN51165Detroit Public Schools Community District · Detroit, MIN51167Cusick Christopher J · La Jolla, CAN51168Cherry Hill Aviation C182 LLC · Freetown, INN5116ABatch Bryan A · Spokane, WAN5116BQuantum Aviation LLC · Manchester, MDN5116DRoche Patrick R · Wichita Falls, TXN5116FMancuso Donald R · Weatherford, TXN5116JCarll Elizabeth M · Chicago, ILN51170Northern Sonic Alaska Inc · Fairbanks, AKN51171Spruill William F · Wyoming, DEN51174Tomah Flying Club Inc · Kendall, WIN51177Mohiuddin Waqar S · The Woodlands, TXN51178Tussey Mountain Flying Club LLC · State College, PAN5117ANorthwest Aircraft Maintenance LLC · Springdale, ARN5117DAndre Kashierski · Estill Springs, TNN5117EJav Air Services LLC · Anchorage, AKN5117G5117g LLC · Sandy, ORN5117QBush Thomas D Jr · Cypress, TXN51186Jones Stephen C · Wadsworth, ILN51188Yuma Aero Services LLC · Yuma, AZN51189Caufman Roger B · Loganville, GA
Back to AD 79-10-14 R1