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.
N6275RFoode Frank J · Cordova, AKN6275SMichigan Dept Of Natural Resources · Roscommon, MIN6276BN6276b LLC · Katy, TXN6276FHubler Bruce F · Caldwell, IDN62770Hog Island Flying LLC · Winter Park, FLN6277AElliott Aviation LLC · Bliss, IDN6277DBockstiegel Bill C · Leadville, CON6277SJones Joseph L · Saint David, AZN6277TMaier Daniel Edward · Vancouver, WAN6277ZAircraft Guaranty Corp Trustee · Oklahoma City, OKN6278EJ K Sparks Inc · Lutz, FLN6278GAvila Sarah · Long Beach, CAN6278RCress LLC · Dover, DEN6278YTown & Country Aviation LLC · Sunnyvale, CAN62796Kane Chuck · Thousand Oaks, CAN62799Dutchflier Captial LLC · New Hudson, MIN6279NDavan Karissa J · Phippsburg, MEN6279TCragg Gordon E · Georgetown, TXN6279VRegistered aircraftN627ARTextron Aviation Inc · Wichita, KSN627CTCoast Flight Training And Management Inc · San Diego, CAN627DJLarocque Daniel · Anchorage, AKN627EREmbry-Riddle Aeronautical University Inc · Prescott, AZN627KWOrion Aviation Aircraft LLC · Carlsbad, CAN627MHappy Kamper Aviation LLC · Austin, TXN627PL8s1-51 LLC · Polson, MTN627SPFxe Flightcenter Corp · Fort Lauderdale, FLN6280RBredvold Daniel M · Mendota Heights, MNN6280VHenneberry Joseph Paul III · Pilot Hill, CAN6281APowell Alvin · Caldwell, IDN6281EPlunk Ben · Mesquite, TXN6281FAurora Aviators LLC · West Linn, ORN6281TSalyer Arthur W · Temecula, CAN6282ASullivan Christopher M · Harvey, ARN6282BBig G Air LLC · Durango, CON6282DPlane Junkies LLC · Dover, DEN6282KLowder Harold E · Fresno, CAFirst renewal noticeN6282SWorth William D · Huntington Beach, CAN6283AMuffett John D · Moore, IDN6283RAkchak Air LLC · Leeds, UTN6283SMorris Kristina T · Ventura, CAN6283VAxley Micheal S · Portland, ORN6284ECastle Donald L · Auburn, CAN6284FMathews Wade A · Wichita Falls, TXN6284RTop Aircraft Leasing LLC · Wilmington, DEN62853Willkomm John C · Kenosha, WIN62855Pterosaur LLC · Cumming, GAN6285AMiller Scott D · Elsie, MIN6285FWright Base Flight Training LLC · Tullahoma, TNN6285HWhitetail LLC · Anchorage, AK
Back to AD 79-10-14 R1