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.
N400GEFreeway Airport Inc · Mitchellville, MDN400GFLively Joshua · Montague, MAN400GMN400gm LLC · Salisbury, MDN400GTDelaney Holdings LLC · De Witt, IAN400HA15 Corp · Lansing, MIN400HDSpitzer Helicopter LLC · Wilmington, DEN400HG5sfcapital Holdings LLC · Newark, DEN400HVReilly Herbert V · Bloomingburg, NYN400HWHotel Whiskey LLC · Sylvania, OHN400HXTevis David James · Colorado Springs, CON400JCRegistered aircraftN400JGParsons David E · Panama City Beach, FLN400JRAirspeed Investments LLC · Springfield, TNN400JSKing Canyon Buffalo Inc · Denver, CON400JWAirfleet Holdings LLC · Beverly Hills, CAN400KClydesdale Asset Management LLC · Park City, UTN400KBArrowhead Circle Leasing LLC · Cedar City, UTN400LDreher Steve · Bettendorf, IAN400LBAutumn Crocus LLC · Cincinnati, OHN400LFBoboltz Randy · Hector, MNN400LLMentor Flyers Inc · Paragon, INN400LMGoldberg Gary S · Rockville, MDN400MAPetersen Jacob R · Wasilla, AKN400MERegistered aircraftN400MJHaney Michael W · Tehachapi, CAN400MTSpevco Inc · Pfafftown, NCN400NEKisska Michael K · Long Beach, CAN400PBonanza V35 LLC · Bakersfield, CAN400PFH Richardson & Sons LLC · Ogdensburg, NYN400RCSpiwak Andrew J · Canyon Lake, TXN400RNGuirguis Samuel · Fort Myers, FLN400RUBell Jake T · Lexington, KYN400SDLeonard Tyler D · Newbury Park, CAN400TDHardy Mikel · Twin Falls, IDN400TVA & A Farms Inc · Arbuckle, CAN400UBoard Of Regents Of The University Of Oklahoma · Norman, OKN400UHUhi Inc · Provo, UTN400VHalford John · Ballinger, TXN400VVCarver Aero LLC · Muscatine, IAN400VWSpuza Dan D · Sanger, TXN400WOzment Dennis W · Palmyra, MON400WEOberti Gary A · Hillsborough, CAN400WHHorrigan William Jr · Roxbury, CTN400WMBryan Craig · Ellisville, MSN400WRBrown Jon R · Palm City, FLN400WTArtspret Aviation LLC · Sugar Grove, ILN400YCTuca 27 LLC · Lewes, DEN4010ARegistered aircraftN4010BEmerald City Aircraft Leasing Inc · Port Orchard, WAN4010YRegistered aircraft
Back to AD 2007-04-19 R1