AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N8492LCarey Thomas A · Carabaset Vly, MEN8492PKovacevich Rudy · Fowler, OHN8492WMoore Myron Keith · Amarillo, TXN8492YGaipa Timothy A · Saint Joseph, MIN84938Shearer Don E · Madrid, IAN8493FCharles City Aeronautics Inc · Charles City, IAN8493LBriss David S Dmd · Somerset, NJN8493RCapital City Flyers LLC · Thomasville, GAN8494DKincaid Jonathan A · Frankfort, MEN8494FPlane Viewing LLC · Colbert, WAN8494LHess Garrett · Fullerton, CAN8494RCactus Air Gold LLC · Mesa, AZN8495FKing Robert M · Fall River Mills, CAN8495KWeis Allen R · Chancellor, SDN8495WSensenig Landis · Owen, WIN8496FSoriano Juan H · Travelers Rest, SCN8496WKnapp Richard M · Dallas, TXN8496YOsiol Russell E · Chicago, ILN8497WAndrews James E Jr · Cantonment, FLN8498DBig Boy Business LLC · Oklahoma City, OKN8498LWestern Slope Aviators LLC · Delta, CON8498RLangeland Carrol · Menno, SDN8498WPetry Scott A · Greenfield, INN8498YHaigh Joseph C · Rocky Ford, GAN8499BJackson Paul Douglas · Chesapeake, VAN8499DHolton Randall B · Folley Beach, SCN8499LKennedy Christopher S · Canton, ILN8499RZoss Curtis · Pensacola, FLN8499WNazif Ziad J · Denver, NCN8499YKitchen Phillip L · Waterloo, ILFirst renewal noticeN849AScharf Mark T · Rosamond, CAN849AAAb Prop Plane I LLC · Metairie, LAN849BTPeacock Group LLC · Clermont, FLN849GSEskridge William · Cheraw, SCN849JBeam Jeffrey W · Arkansas City, KSN849MDDeaton Mark A · Gig Harbor, WAN84ABBald Eagle Aero LLC · Chesapeake, VAN84AGHillman William W · Oro Valley, AZN84AJPa-18 LLC · South Portland, MEN84ATJ Squared Enterprises Corp · Hendersonville, TNN84BMMcminn Brian R · Rushville, INN84CBRegistration Pending · Buda, TXRegistration pendingN84CDMatteson Robert L · Williamson, GAN84DHStanton Mark I · Spokane, WAN84DJRuhnau Darren S · Park City, UTN84DKJeffreys Joseph C · Lancaster, CAN84DLAirplanes And Helicopters Of Oregon LLC · Sisters, ORN84DWBuffalo Valley Aviation LLC · Neosho, MON84EMPinegar Aviation Services LLC · Ridgeland, SCN84ESSwan Earle F · Bradenton, FL
Back to AD 90-04-06 R1