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.
N32192White Charles J · Spring Lake, MIN32194Parker Brandt · Hillsboro, WIN32196Overstreet Bradley · Greenville, SCN32198Garrison Resource Development LLC · Bridgeport, TXN3219FTop Flight Detail LLC · Middlebury, INN3219GWest Mi Shooting Alliance For Excellence Sfty LLC · Marne, MIN3219PShoot LLC · River Ridge, LAN3219RSotelo Aviation LLC · Naples, FLN3219SYogodzinkski Steve M · Amberson, PAN321AAltman Mchael A · Austin, TXN321ABAmbrosini Alfred F · Connellsville, PAN321ALFincher William T · Chandler, AZN321AYCameron Kari L · Ashland, ORN321AZBuilders Aviation LLC · Algona, IAN321BValdez Aero Inc · Wilmington, DEN321BCGeorge Nathan V · Dardanelle, ARN321BGItinerant Orl LLC · Columbia, SCN321BHKinkel Philip J · Bow, WAN321BLWalls Bruce · Middletown, OHN321BSBrown Gregory N Trustee · Flagstaff, AZN321BURegistration Pending · Tavares, FLRegistration pendingN321BWAero Marine Inc · Westland, MIN321BYStates Thane · Boise, IDN321BZJakes Air Service LLC · Holt, FLN321CEGreen Eggs And Ham Aero LLC · Helena, MTN321CFTekswork Aviation LLC · London, KYN321CGSuper 700 LLC · Robbinsville, NJN321CHSmith James Christian · Rockport, TXN321CKFairwinds Aviation LLC · Goldsboro, NCN321CUStambaugh Scot D · Bainbridge Island, WAN321DBDc Aviation Maintenance Inc · Bryant, ARN321DDGreene Jonathan U · Pompano Beach, FLN321DFFranklin David A · Sealy, TXN321DGAdkison Edy P · Riverside, CAN321DKTwi Air LLC · Picayune, MSN321DNBrookway Aviation LLC · Brookhaven, MSN321DPDelta Papa LLC · Henderson, NVN321DRSavakinas Alan M · Clarence, NYN321DSYoung Winston Shannon Jr · Del Rio, TXN321DWJsj LLC · Wilmington, DEN321EEVermont Skydiving Adventures Inc · Addison, VTN321EFRengel Richard J · Tustin, CAN321EPEpic Aviation Inc · New Smyrna Beach, FLN321ESQualitair LLC Trustee · MichelstadtN321FSUtah State University · Logan, UTN321GBTwisted Roots Aviation LLC · Chesterton, INN321GDFirst Light Inc · Lafayette, LAN321GTBennett Craig · Newbury Park, CAN321GW321gw LLC · Chico, CAN321HDodson International Parts Inc · Rantoul, KS
Back to AD 2007-04-19 R1