AD 96-03-13
Registered aircraft · 1,042
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-03-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:96-03-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:96-03-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:96-03-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.
N57BDynamic Avlease Inc · Bridgewater, VAN57FTS & H Holdings LLC · Wichita, KSN57GAKa73 LLC · Little Rock, ARN57PASpieker Warren E Jr · Menlo Park, CAN580BAN Flight LLC · Kenedy, TXN580BKJohn Newcomb Enterprises Inc · Blacksburg, VAN580SBott Radio Network Inc · Gravois Mills, MON581EAElite Medical Air Transport LLC DBA · El Paso, TXN585CEAugusta Aviation Inc · Hilton Head Island, SCN585RBPonderosa Aviation LLC · Safford, AZN586UCMegel Air LLC · Cleveland, GAN587TWAircraft Security Corp · Laredo, TXN58AYAviapa Flight LLC · Doylestown, PAN58QDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeN593GGCircle S Air LLC · Wilmington, DEN597BAMca-Plane LLC · Grand Blanc, MIN597MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN599CZN599cz LLC · Milwaukee, WIN59ALBilly Ray Casteel LLC · Russellville, ALN59BWStandridge Color Corp · Social Circle, GAN59EKCrosby Richard · Macon, GAN59MDynamic Avlease Inc · Bridgewater, VAN5AETenax Aerospace LLC · Ridgeland, MSN5AHEmpire Air LLC · Indio, CAN5PXRed Poodles LLC · Boston, MAN5STDe Paz Aviation LLC · Coral Gables, FLN600RKLc Whitford Co Inc · Wellsville, NYN600WADothan Security Inc · Dothan, ALN601CWFree Bird Aviation LLC · Ridgeland, MSN6045STexoma Building Services LLC · Kingston, OKN605EAChip Aviation LLC · South Pittsburg, TNN605JDM2driver LLC · Midland, TXN6069AAt Aero LLC · Wilmington, DEN606CMSeagull Aviation LLC · Larkspur, CAN607FJGuardian Flight LLC · Lewisville, TXN60RADodson International Parts Inc · Rantoul, KSN60TJArk Leasing Inc · Newport Beach, CAN610TANorth Flight Aero Med · Traverse City, MIN611SDGreen Diamond One LLC · Knoxville, TNN613GAGaf Holdings Inc · Visalia, CAN613TAWild Blue Aviation LLC · Wilmington, DEN618United States Department Of Interior · Boise, IDN6182AA&R Air Inc · Hinsdale, ILN619DDPark Avenue Group Inc · Stuart, FLN619PAPafford Air Of Mississippi LLC · Ruston, LAN61APTrewhitt Jamie Mcmahan · Pacific Palisades, CAN61AYAonvo Investment LLC · North Miami, FLN61DNDn2 Aviation LLC · Fernandina Beach, FLN61PCN61pc Leasing LLC · Ponca City, OKN61PEHc4 LLC · Fair Play, SC
Back to AD 96-03-13