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.
N5627AKeiffer Robert P · Piney Flats, TNN5627BTaylor Tona R · Graham, WAN5627RBitikofer Brent E · Kansas City, KSN5627TSchulte Lawrence · Griffin, GAN5628AMaldonado Alejandro · Minneapolis, MNN5628CEllis George T · Mt Chase, MEN5628GJewell Jonathan T · Paducah, KYN5628JAviate 208 LLC · Oconomowoc, WIN5628RKellam Garnett A · Mappsville, VAN5629CSchultz Philip W · Lancaster, CAN5629ECueva Arturo A · Los Angeles, CAN5629RSadie Hawk Aviation LLC · Collinsville, CTN5629T5629t LLC · Denison, TXN562ABNavigation Leasing LLC · Castle Rock, CON562ACN91934 LLC · Evergreen, CON562AEL-Bird LLC · Hood River, ORN562AFMustang Sally Aviation LLC · Camden, SCN562ATOmahen Gilbert H · Northridge, CAN562CBKqm Aviation · Bristow, VAN562DGB2d LLC · Wickenburg, AZN562FElite Approach LLC · Chesterfield, MON562GSHermann Andrew L · Kindred, NDN562NDSpartan Education LLC · Tulsa, OKN562SVAv8tr Holdings LLC · Kent, NYN5630ABrockmeyer Cory · Auburn, ILN5630BJohnstone Karl S · Anchorage, AKN5630CMallamo John · Shell Knob, MON5630EHolliday Mark E · Lake Elmo, MNN5630RLanas Flying Machine LLC · Hollywood, FLN5630TBolin Matthew R · Everett, WAN5631BZufelt Robert H · Nampa, IDN5631EN141ns LLC · Lantana, FLN5632BPasahow David R · Fredericksburg, TXN5632THodder Philip Michael · Houston, TXN5633CWinkler William P · Granbury, TXN5633RBirds Eye View LLC · Nampa, IDN5635ADecoteau Mitchel E · Yellville, ARN5635ECircle W Flying Club Inc · Creighton, PAN5636AFine Aviation LLC · Jefferson, ORN5636EHirt David M · Marblehead, OHN5636RSkyhawk Aviation LLC · Ogden, UTN5636TRegistered aircraftN5637ASherman Frederick J · Tukwila, WAN5637GN2893e LLC · Reno, NVN5637TBarbour George E Jr · Croydon, NHN5638AHartigan Robert P · Rome, NYN5638BBowman David R · Julian, NCN5638ENorthern Ventures II LLC · Missoula, MTN5638RBurkhart Andrew · Toccoa, GAN5639CSpruill William F · Wyoming, DE
Back to AD 79-10-14 R1