AD 96-10-01 R1
Registered aircraft · 8,139
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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.
N8363RHancock Allen L · Twentynine Palms, CAN8363WRegistered aircraftN8364RSwank Freeman J · Fort Myers, FLN8365RRegistration Pending · Lake City, FLRegistration pendingN8365WAbramczyk Randall L · Delta, OHN8366RMoyer Jay R · Corry, PAN8367RNorthwest Roamers Inc · Eugene, ORN8367WBreeze Through LLC · Brooklyn, NYN8368RLive And Give Foundation Management Group LLC · Huntsville, TXN8368WIronwing Aviation Group LLC · San Diego, CAN8369RWolfgang Aviation LLC · Lynnwood, WAN8369WDunagan Jimmy Miles Jr · Trenton, TNN8370CFigueroa Daniel · Dorchester, MAN8370RYandik Stephen E Jr · Hudson, NYN8370WTaylor Tmothy P · Watford City, NDN8371WDavis Kyle G · Weatherford, TXN8374WMartin Rebecca · Bothell, WAN8375RCarlton John B · Lenoir, NCN8375WSingh Harbans · Las Vegas, NVN8376RRegistration Pending · Wshngtn Ct Hs, OHRegistration pendingN8376WSale Reported · Crystal, MNSale reportedN8377RPerry Eden · Morgan Hill, CAN8377WRosenberg Adam N · Scottsdale, AZN8378RNachbar Scott G · Springville, NYN8379WChilds Electric Inc · Dawson, GAN8380WForbes Aviation LLC · Boise, IDN8382WTrans Western Air Inc · Cullowhee, NCN8383WMj Aero LLC · Mims, FLN8384WWilt Jared C · Marysville, OHN8385WJohnson Robert J · Floral City, FLN8387CRuday Dennis J DBA · Glendora, CAN8387RMiloud Chadd K · Fort Worth, TXN8387WHolt Zachary Ian · Bogalusa, LAN8388RFloyd James · Gainesville, TXN8388WWatts Timothy S · Denver, NCN8389WStegemoller Ronald G · Washington, TXN8390WLong Joseph · Mint Hill, NCN8391WNavara Cole J · Ulster Park, NYN8393RFisher B Barton · Bowman, NDN8394WLockhart Flying Club · Lockhart, TXN8395RRegistration Pending · Dover, DERegistration pendingN8396RPatton Graham S · Chattanooga, TNN8396WCarpenter Kenneth G · Dripping Springs, TXN8397RMiller Dean R · Edmond, OKN8398RParker Jeffrey S · Aurora, OHN8398WFlaspohler David E Trustee · Lake Lotawana, MON83BETecce Andrew J · Cambridge, MDN83LMJohannsen Gregory A · Salina, KSN8401RLaplante David W · New Baltimore, MIN8402CConner W Larry · Los Lunas, NM
Back to AD 96-10-01 R1