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.
N6164TRubin Andrew C · Rochester, NHN61651Clw Aviation LLC · Springville, ALN61653Michel Daniel T · Sterling, AKN61655Air Planes LLC · Soddy Daisy, TNN61656Dismang Chad C · Boynton, OKN61657Bell Ornithopters Flying Club Inc · Eastlake, CON61658Nationwide Aviation LLC · Hudson Oaks, TXN61659Bowerman Richard E · Wetmore, MIN6165EBailey Frank W · White City, ORN6165FMainely Lobsters · Gulf Breeze, FLN6165GPartida Carlos · Delray Beach, FLN61662Huston Stephen M · Hollister, CAN61663Mohamed Eman Z · Lubbock, TXN6166EAshabranner Kevin T · Port Saint Joe, FLN6166NBrian C Haggerty LLC · Pembroke Pines, FLN6166UBb Aviation LLC · Prescott, AZN61670Registered aircraftN61671Charlotte Flyers Inc · Fort Myers, FLN61672American Patrols Inc · Midland, TXN61676Vectors LLC · Sterling, VAN61677Morcom Aviation Services Inc DBA · Everett, WAN6167BEdwards Darrell R · Artesia, NMN6167CSnyder Larry G · Holland, NYN6167EMiller James C III · Papillion, NEN6167FJohnson Susan J · Chelan, WAN6167KDuncan Marianna G · Lufkin, TXN6167LEastern Cincinnati Aviation Inc · Batavia, OHN6167NMillhorn Farms Inc · Worley, IDN6167TBurton William F · Shiloh, NJN61680Kaye Linda · Grove, OKN61683Migdalski Randall C · Pembroke Pines, FLN61684Odyssey Aircraft LLC · Topeka, KSN61687Advanced Rehab Specialties Pa · Leesburg, FLN61689Bc 414 LLC · Los Angeles, CAN6168BSafety Source LLC · Kirkland, WAN6168EFoster Marcus R · Mesa, AZN6168NRegistered aircraftN61692Pittsburgh Institute Of Aeronautics · West Mifflin, PAN61696Bakker Margaret E Trustee · Petaluma, CAN61697L&W Aircraft Investment LLC · Homestead, FLN61699Erickson Steve · St Michael, MNN6169BTjs Plane LLC · Renton, WAN6169EVick Troy · Normangee, TXN6169FWatrud Joel Carl · Waskish, MNN6169GKingdom Air Corps · Sutton, AKN6169RN999gk LLC · Nantucket, MAN6169TZelner Gregory · Merritt Island, FLN616AADowns Kenneth · Houston, TXN616CPTextron Aviation Inc · Wichita, KSN616FKenzy 2020 LLC · Aurora, OR
Back to AD 79-10-14 R1