AD 84-10-01 R1
Registered aircraft · 20,483
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:84-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:84-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:84-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:84-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.
N3499VSponsler William D · St Charles, ILN349PSBrowning Amy S · Knoxville, TNN34BBMcvay Larry A · Boise, IDN34BTWilliams Charles R · Wadsworth, OHN34CFPayne James Michael · Twin Falls, IDN34DMGlotfelty John E · Durango, CON34DWDarvis Enterprises LLC · Addison, TXN34FFZwierlein Victor · Grand Prairie, TXN34JSJ & K Aviation LLC · Bristow, OKN34KBReilly Donald H · Micco, FLN34LGCruz Aviation LLC · Holmdel, NJN34PScootair LLC · Alburgh, VTN34SRL-Bird LLC · Hood River, ORN34VVWattum Investments LLC · Kodiak, AKN3500FN3500f LLC · Jennings, LAN3500MNagy Sandor · Monterey, CAN3500YTuff Aviation LLC · Belmont, MIN3501RStanislaus County Sheriffs Department · Modesto, CAN3501UN3501u LLC · Tulsa, OKN3502FLange Clifton E · Inez, TXN3502UStreamline Business Management · Citrus Heights, CAN3503HRansom Woodbury S Trustee · Lansing, IAN3503YNorthern Lights Renewables LLC · Condon, MTN3504FBraden Peter S · Elizabethtown, KYN3504YThigpen Alec DBA · Spanish Fort, ALN3505FWade Bradley S · Waterman, ILN3506QEjair LLC · Shelburne, VTN3507YAyers Curtis W · Greenback, TNN3508FStephen G Dill Dvm LLC · Remington, VAN3509UGarrett Robert L · N Richland Hills, TXN3509YAnderson Kevin · Verona, NDN350TMJefferies Stanley J · Coos Bay, ORN3510FHughes Ramzi Sanford · Alamo, NVN3511FHardison Charles M · Granbury, TXN3511YJ F Jones Logistics LLC · Dallas, TXN3512FNourbakhsh Illah R · Pittsburgh, PAN3512UN3512u LLC · Ruidoso, NMN3513TCrusade Investments LLC · Ardmore, OKN3513UDieck Michael N · Raleigh, NCN3514FSullivan Kelly J · Chandler, AZN3514YCielakie Edward W · Dracut, MAN3515USchettler Patrick J · Garnett, KSN3515YInflyt LLC · Carlsbad, CAN3516FWhittock Tyson H · Anchorage, AKN3516GHepler William J · Gratz, PAN3516YMks Aviation LLC · Port Orchard, WAN3517UAddison Robert M · Fort Sumner, NMN3517YRobles Serafin M · Cynthiana, KYN35183Stone Industrial Contractors Inc · Savannah, GAN35184Maliszewski William F · Independence, WI
Back to AD 84-10-01 R1