AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N2776EAugusta Flying Club Inc · Martinez, GAN2776FBabovic Slobodan · Elm Grove, WIN2776GOliver Charles D · Saint Albans, WVN2776JMission Aviation Fellowship · Nampa, IDN2776LRd Aire LLC · Opelika, ALN2776UGarrison Randy · Queen City, TXN2776XSmith James A III · Millerton, NYN2777ETop Flight Aviation Inc · Corona, CAN2777GPacheco Randy L · Pacific Grove, CAN2777JFirst Flight LLC · Craig, AKN2777LHataway Gregory L · Kinston, ALN2777TAviator Air Flight School LLC · Grand Prairie, TXN2777XKruskie Douglas · Petoskey, MIN2778FHuber George M · Bentonville, ARN2778JWilfer Dennis M · Fairbanks, AKN2778SStamper Brian L · Tucson, AZN2778URoberts Kenneth B · Wall Township, NJN2779FSweatt D Wayne · Memphis, TXN2779LResetar Douglas J · Pittsford, NYN277CBN277cb LLC · Jacksonville, FLN277JKcsi Aerial Patrol Inc · Bakersfield, CAN277KLCoombs Johnnie · Blue Mountain, MSN277NWindh Randall · Reedley, CAN277RTGonzalez Edwin A · Scott Afb, ILN277SLCharlies Wings LLC · Salisbury, NCN277TMPollock Donald Edward · Union Hall, VAN277XSalopek Rett · Las Cruces, NMN27808St George Flight Academy LLC · St George, UTN2780GHolden Christa · Rougemont, NCN2780SNapolitano Frank D · Howell, MIN2780XMontgomery Jeffrey L · Anthem, AZN2781DFejes Guide Service Ltd · Anchorage, AKN2781JRussell Scott M · Sanger, TXN2781QGibboney Phillip M · Roseville, CAN2781SGadberry Garth · Heath, TXN2781XN2781x LLC · Kingston, GAN2782FMansoori Ali S · Aurora, CON2782LSouthern Seaplane Inc · Belle Chasse, LAN2782QBauer Aviation LLC · Reese, MIN2782UFrazier Doris C · Keller, TXN2783FVspp Consulting LLC · Stevensville, MDN2783GLarue Terrence W · Ellensburg, WAN2783TCloud 9 Aviators LLC · Anchorage, AKN2784GFlaps Up LLC · Kaysville, UTN2784SThomas Michael R · Marshall, MON2784UCobb Robert · Elberton, GAN2784XGillett Welles III · Horseheads, NYN2785FAugustin Lyn H · Saint Thomas, NDN2785JDurtschi Steven R · Centerville, UTN2785KPontiac Flying LLC · Pontiac, IL
Back to AD 97-01-13