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.
N54479Two2fly Aviation LLC · League City, TXN5449WBlue Skies Aviation Inc · Lowville, NYN544TAWright Richard L Jr · Flower Mound, TXN5450WChambers Kirk · Delta, OHN5451WAndre Craig W · Pierre, SDN5453WWheeler Dale · Valencia, CAN5457STyler David G · Accomac, VAN5458MPagratis Periklis · Savannah, GAN545CARegistration Pending · Wilmington, DERegistration pendingN545FLWiegand Andrew S · Enterprise, ALN5460NWylie David · Sharon Springs, NYN5461WGarvey David G · Erie, PAN5463WAngels Envy Aviation LLC · Denison, TXN5465WCotrell Rick G Trustee · Troy, OHN54665Registration Pending · Talking Rock, GARegistration pendingN5467SBlach Edmund Jerome · Nashville, TNN5467WGovender Sagren K Jr · Houston, TXN5468WSitton David F · Mebane, NCN5470WRegistration Pending · Bulverde, TXRegistration pendingN5471WBartholomew Charles Scott · Newburyport, MAN5473WMathews Derek A · Burlington, KYN5474SHiggs Mark P · Monett, MON5475WWing & A Prayer LLC · Moreland, GAN5476WTalon Aviation LLC · Greenville, MIN5477WAchi Inc · San Jacinto, CAN547CACareer Flyers LLC · Crittenden, KYN547FLNgugi Samson W · El Paso, TXN547RSMawson Richard · Katy, TXN5480WAikin Denver · Owasso, OKN5481WBawden Frederick M · Brookfield, WIN5488TWestphal Ronald R · Aurora, ILN5490WHobbs Alicia · Folsom, CAN5492WSky Park Cherokees Inc · Felton, CAN5495WWings Over Lake Norman LLC · Mooresville, NCN5496WMaddux Dawayne E · Weeki Wachee, FLN5497WJethro Charter Flights LLC · Jacksonville, NCN5498WBas Part Sales LLC · Greeley, CON5499WVerchick Peter A · Jacksonville, FLN54MTMay Rose Ellen · Hampshire, ILN5500UJones Donald T · Barrigada, GUN55010Royal Aviation Academy LLC · Sarasota, FLN55018Stiver Roger M · Nashville, ARN55019Berry Kirby T · Poolville, TXN5501FWade Joshua Michael · Saline, MIN5501WTailwinds Aviation LLC · Kokomo, INN55021Robertson Alan L · Hastings, NEN55028First Alarm Aviation LLC · Fosters, ALN55029Chandler William John · North Palm Beach, FLN5502WWest Kentucky Wings And Toons LLC · Benton, KYN5503FN5503f Aircraft Holdings LLC · Orangeburg, SC
Back to AD 96-10-01 R1