AD 56-06-01
Registered aircraft · 15,141
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:56-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-06-01')
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:56-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:56-06-01') 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.
N10006Coutches Robert Hercules DBA · Livermore, CAN1000THaughton Douglas L · Gig Harbor, WAN1000YBarkhimer James C · Iraan, TXN1007THollar Larry · Winston Salem, NCN1009PFerrier William T · Woodland, CAN100CAFass Flyers LLC · Garden Ridge, TXN100FPFlying Particles Inc · Livermore, CAN100KFAlbrecht Douglas D · Hobart, INN100MMFarmer Aviation LLC · Milan, MIN100SDDivan Jeremy E · Castle Rock, CON100SFSafe Flight Instrument LLC · White Plains, NYN100SLOlson Gordon N · Racine, WIN1011SAfrican American Airlines Inc · Brandon, FLN10133Fisher Charles R Jr · San Antonio, TXN10145Hensarling Matthew L · Elizabeth, CON10176Abm Flights LLC · Pawleys Island, SCN101APatterson Mark T · Kodiak, AKN101GHSan Diego Community College District · San Diego, CAN101KTBryan Jerry E · Kathleen, GAN101RGTree Air LLC · Vero Beach, FLN101SPHawkes Clark · Gillsville, GAN101TCTcm Flying Club Inc · Mobile, ALN101WPScc Associates Ltd · Wilmington, DEN1020MWinner Philip · Houston, TXN1021CRiener Clinton G · Cottonwood, IDN1022MHilton David L · Shreveport, LAN1022THansen Jed D · Clark, SDN1024MEdwards Chris R · Meadow Vista, CAN1025MSupina Robert P · Richmond, TXN1027XHarper Shawn · Bayfield, CON1028MWenz Michael D · Gillette, WYN102CDrain Alan K · Columbus, MTN102PSHunt Jimmie · Leary, GAN10319Battle Creek Aero Club Inc · Kalamazoo, MIN10322Skyview Resources LLC · Holland, MIN1037BSky West Aviation Inc Trustee · Albuquerque, NMN1037TJohnson Shem E · Bonners Ferry, IDN1037VPulse Jeremy D · Moore, MTN103PBBentley Jeffrey W · Kenmore, WAN1041MHubbard Bennett L · Piedmont, ALN10442Hilty David J · Kodiak, AKN10445Hartz Mark E · Stuttgart, ARN1046WGoodin Ross W Jr · Enterprise, MSN104BU1984k LLC · Gypsum, CON104HSErdmann Hollis K · Santa Monica, CAN104NRMiller Dale D · Eagle River, AKN104PSouthern Aircraft Consultancy Inc Trustee · Casper, WYN104PMPats Offroad Inc · Mitchell, SDN104SPJanaitis Aviation LLC · Middletown, DEN1050VState Of Wisconsin · Madison, WI
Back to AD 56-06-01