AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N3448PDabney Richard W · Tanner, ALN3448QSand Hill Ranch Ltd · Decatur, TXN3448RFour Eight Romeo LLC · Shallowater, TXN3448UHigh Planes Flyers Inc · Fort Collins, CON34490Peterson Frazer C Trustee · Payette, IDN34491Hazelwood Dennis L · Mount Vernon, MON3449FKunkel John A · Pine River, MNN3449MCarhart Thomas M · Galesville, WIN3449RRobinson Timothy A · Casa Grande, AZN3449THedrick Bill E · Kilgore, TXN3449UHicks Brian Joseph · Shingle Springs, CAN3449YSteel Rock Aviation LLC · West Jordan, UTN344AHAdams Flying Service Inc · Rayville, LAN344AJQualitair LLC Trustee · MichelstadtN344AKChavi LLC · Fredericksburg, TXN344ATTagir Abkadirov · Tampa, FLN344BCote Stephen P · Montgomery, TXN344BAWoodring Mark W · ProvidencialesNon-citizen corporation, flight hours not reportedN344BBMansfield Heliflight · Milton, VTN344BHBlack Hills Aviation Leasing LLC · Rapid City, SDN344BLWingsleasing LLC · Wichita, KSN344CACivil Air Patrol · Maxwell Afb, ALN344CCDorsey Dale · Charlotte, NCN344CDAircraft Guaranty Corp Trustee · Oklahoma City, OKN344CFKey West Helicopters LLC · Key West, FLN344CRPattern Altitude Aviation Standards LLC · Sandy, UTN344DProfessional Training Aircraft LLC · Wilmington, DEN344ESLake Superior Helicopters LLC · Duluth, MNN344GStobbe Marlin · Ethridge, TNN344JEAlf Ix LLC · Chicago, ILN344JGSmith Helicopters Inc · Cotulla, TXN344JPCentral Virginia Aviation Inc · North Dinwiddie, VAN344JSWhitewing Aviation LLC · Tuscola, TXN344KLeblanc Debrah · Zachary, LAN344KVLutz Gregory J · East Bridgewater, MAN344LCDuyk Charles W · Saint Petersburg, FLN344LRRotor Scooter LLC · Hauppauge, NYN344MARomeo Romeo LLC · Lewes, DEN344MGAir Service LLC · Wilmington, DEN344MTPalomino Creek LLC · Missoula, MTN344PCFlorida Cap Property Management Services LLC · Fort Lauderdale, FLN344RBContinental Aerospace Technologies Inc · Mobile, ALN344RLRed R44 LLC · Wilmington, DEN344SRegistered aircraftN344SAShier Aviation DBA · San Diego, CAN344SGGoldman Glenn D · VaughanN344SPSun City Aviation LLC · Davie, FLN344YUniversity Of North Dakota · Grand Forks, NDN344ZGlobal Pilot Inc · Wilmington, DEN34500Miller Judy Carole · No Palm Beach, FL
Back to AD 2007-04-19 R1