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.
N5038TBennett Howard N · Georgetown, KYN5038WMarx Karl E · Juneau, AKN5039TMitchell Robert D · Freehold, NYN5040TGamblin Ryan · Perry, GAN5043WRushton Harold E · Nashville, TNN5044MMojocreatives Inc · Avondale Estates, GAN5045TTruex Theodore L · Peachtree City, GAN5046TStp Flight LLC · Saint Paul, MNN5047WCooper James · Indianapolis, INN504FLMustafa Abdelrahman · Euless, TXN5050WLadeira Victor E · Holy Cross, AKN5052TMatos Jonathan A · Kent, WAN5053TSchneckenburger Kurt Partrick · Bethesda, MDN5053WJonason David · Ocean Park, WAN5057TGiber Michael S · New Port Richey, FLN5058TRebel Aviation Inc · Liberty, MON5059TGimenez Roberto Jorge · Merritt Island, FLN505FLComer Christopher C · Randleman, NCN5063TKramer Ryan T · Hector, MNN5065WAddai Emmanuel · Cincinnati, OHN5069WNelson Stephen A · Milaca, MNN5071LHill Karl D · Igiugig, AKN5071WWallace Madison F · Thomasville, NCN5072WHurst Randall S · Altus, ARN5074WWells Byron R · Bunn, NCN5077WSkyport Aviation LLC · Birmingham, IAN507FLSpence Ryan · Chicopee, MAN5080WMatzke Kevin T · Gilbert, AZN5084WShouse Robert G · Owasso, OKN5085WMartin Marlin Ray Jr · Mabank, TXN508THFowler David P · Freeport, MEN5090WJaybird Aviation LLC · San Antonio, TXN5091WRegistration Pending · Anchorage, AKRegistration pendingN5093SPerez Matthew C · Indianapolis, INN5096TRichards Lyle D · Riley, KSN5099TClark Darril W · Scappoose, ORN50YRBrowning James M · Milaca, MNN5100LWilder Carl T · Budd Lake, NJN5100SParks Victor Lee · Houston, TXN5101GWash Stephen · Franklin, TNN5102GHeussler Ryan · Rio Dell, CAN5102SK & N Aviation LLC · Rock Hill, SCN5103GMcfarland Les · Bourbon, INN5104LLamer Roland W · Fresno, CAN5105SSyphers Harold A · Aguila, AZN5106LArnold John D · Reno, NVN5107LSmith Jeremy · Houston, TXN5109GSnamiska Kyle · Cypress, TXN5109SBucek James A · Baytown, TXN5110GN5110g LLC · Orlando, FL
Back to AD 96-10-01 R1