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.
N207GHBridgeview Aviation LLC · Southfield, MIN207GMWaters Aero Marine Inc · South Thomaston, MEN207GRBlue Sky Telluride LLC · Telluride, CON207HAP & C Leasing LLC · Jupiter, FLN207HPCampbell James W · Geneva, ALN207JPWaters Aero-Marine Inc · Owls Head, MEN207JVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN207MRVanderpool Robert W Sr · Red Devil, AKN207NEHylton Kyler E · Palmer, AKN207NNCasaccio Paul E · Beesleys Point, NJN207PAMcnutt Ross T · Xenia, OHN207RADelta Investment Group LLC · Memphis, TNN207RBSutton Aircraft Salvage LLC · Palmer, AKN207RS5m Consulting LLC · Uvalde, TXN207SRJaars Inc · Waxhaw, NCN207TFPhotos Unlimited Inc · Rancho Cordova, CAN207VWVanderwel Mark E · Monroe, WAN207WWalters William L · Boise, IDN207YHGrant Aviation Inc · Anchorage, AKN208Jmp Aircraft Services LLC Trustee · Wasilla, AKN20801Loveland Christopher K · Meridian, IDN20803Goad Jimmy L · Bradford, ARN20804Ceddia Stephen J · Framingham, MAN20805Welzenbach Craig L · Fair Oaks Ranch, TXN20806Young Todd Frederick · Pensacola, FLN2080EBean James P · Tulsa, OKN2080JWoelfel Tim A · Madisonville, TXN2080RTigert Tommy Ray · Ovilla, TXN20811Rtd Aviation LLC · Hillsborough, NJN2081ZMcfarland Ryan E · Jacksonville, FLN20820Maugeri Thomas V · Frankfort, NYN20823American Patrols Inc · Midland, TXN20824Seven Hills Skydivers Inc · Madison, WIFirst renewal noticeN20825Sussman Stanley M · New Castle, DEN20828Merrow R Loring · Beverly, MAN2082GKennedy Daniel M · Boise, IDN2082JCsc Delaware Trust Co Trustee · Wilmington, DEN2082ZRamirez Frank Torres · Santa Rosa, CAN20831Olg Air LLC · Miami Gardens, FLN20832Wallace Fred · Ada, OKN20834Climb Maintain LLC · Morrisville, MON20836Morar Radu · Sutton, MAN20837Mjm Enterprise Holdings LLC · Drexel, MON20838Madden John D · Bellenue, WAN2083QCardinal N2083q LLC · Churchville, PAN2083RSchutze Eric D Trustee · Ojai, CAN2083YJackson David W · Prescott Valley, AZN2083Z343 Aero Club · Bossier City, LAN20841Fox Creek Aviation LLC · Jackson, WYN20842Warner Kenneth G · Granbury, TX
Back to AD 97-01-13