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.
N7862RUas Transervices Inc · Boca Raton, FLFirst renewal noticeN786DDTransouth Leasing LLC · Longview, TXN789CTKingfisher Associates LLC · Wilmington, DEN78DARegistered aircraftN791DCExecutive Air Taxi Corporation · Bismarck, NDN791EBSav Aviation LLC · Jacksonville, TXN793DCBillings Clinic · Billings, MTN795PAPdx LLC · Indianapolis, INN797KDDodson International Parts Inc · Rantoul, KSN799CZN799cz LLC · Milwaukee, WIN799DDRenfro Michael W · Bethel, AKN799MCPerry King Air LLC · Perry, GAN79DMKsg Capital LLC · Casper, WYN79EFPonca International LLC · Ponca, ARN7NANasa Armstrong Flight Research Center · Edwards, CAN800BSM&F Western Products Inc · Sulphur Springs, TXN800PKFarmers Oil Co Inc · Anthony, KSN800TSPetrie Motor Company Inc · Lake Worth, TXN801NANasa Neil A Armstrong Flight Research Center · Edwards, CAN802BAUas Transervices Inc · Boca Raton, FLN803HCH J King Air LLC · Madison, GAN804Abc Aviation LLC · Gonzales, LAN806JMFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN806KMMontana Aircraft Trust Inc Trustee · Bozeman, MTN806LWSac Wild LLC · Loomis, CAN806WBCircle I Air LLC · Lubbock, TXN807SMAurora Air Partners LLC · Portland, ORN808BESkyfall Aviation LLC · Blacksburg, VAN809HCCourson Oil And Gas Inc · Perryton, TXN809PSP & P Air LLC · Wilmington, DEN80CPBf Air LLC · Panama City, FLN80WMAt Aero LLC · Wilmington, DEN812GBTrinity Logistics Holdings LLC · Saint Johns, FLN812TTBranched Oak Charter LLC · Rising City, NEN813BLSarma Aviation LLC · Fort Wayne, INN816BSN811kc LLC · Sunrise, FLN817BAZane Bennett Galleries LLC · Santa Fe, NMN818FWPelican Aircraft Inc · Wilmington, DEN81ETRussell Timothy Lee Jr · Saint Petersburg, FLN81TFA P A C LLC · Berlin, NJN81TLC S & P Rocky Mountain Inc · Cheyenne, WYN820DLEs&E Aviation LLC · Greensboro, NCN821CBEz Transportation Inc · Rosharon, TXN825KASav Aviation LLC · Jacksonville, TXN825STLowcountry Aviation Co Brokerage LLC · Walterboro, SCN826WGSibi LLC · Indianapolis, INN828SSSusanaire LLC · Dallas, TXN829MCKidd Johnston Aviation LLC · Odessa, TXN831MWKdm Ltd · Santa Teresa, NMN831WPVagus Group Inc · Wilmington, DE
Back to AD 96-03-13